Calling procedure through a SELECT

Dúvidas, dicas e truques de SQL, Select, Update, Delete, cláusulas, operações com joins, Funções em SQLs, etc
Post Reply
rickab7
Rank: Programador Sênior
Rank: Programador Sênior
Posts: 53
Joined: Fri, 25 Aug 2006 8:11 pm
Location: campo grande
stephany henrique de almeida batista

Hello everybody!!

I am creating a shopping report for each stock, where it shows the current product balance and the amount of movement determined by a period and how much I need to pass certain days. I would like to know if the product needs a purchase request, as a question of the relative view I can call a procedure to create a purchase request, that is, through a select as I call a procedure.


I would like to thank the help and God bless all
User avatar
dr_gori
Moderador
Moderador
Posts: 5024
Joined: Mon, 03 May 2004 3:08 pm
Location: Portland, OR USA
Contact:
Thomas F. G

Você já respondeu a dúvida de alguém hoje?
https://glufke.net/oracle/search.php?search_id=unanswered

Well, in these cases, I think the best thing to do is open a cursor of your select and if necessary, run your procedure ...
User avatar
TBou
Rank: Analista Sênior
Rank: Analista Sênior
Posts: 136
Joined: Thu, 05 Aug 2004 9:33 am
Location: Campo Grande - MS
Thiago Bourscheidt
thiago.info@apoiorural.com.br
Analista de Sistemas

Looks once I needed something similar then I did a "gambiarra", function that called this procedure, but I had some restrictions on running the function.
I do not remember what the restrictions were, but I have a vague reminder that I could not run the procedure from the function if the procedure had vectors internally.
rickab7
Rank: Programador Sênior
Rank: Programador Sênior
Posts: 53
Joined: Fri, 25 Aug 2006 8:11 pm
Location: campo grande
stephany henrique de almeida batista

The only restriction that has in a select calling a function is that you can not do insert in the bank.
Post Reply
  • Information
  • Who is online

    Users browsing this forum: No registered users and 23 guests