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
Calling procedure through a SELECT
- dr_gori
- 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
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 ...
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.
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.
-
- Information
-
Who is online
Users browsing this forum: No registered users and 4 guests