This content has been marked as final. Show 2 replies
Welcome to the forum!
Unfortunately you have posted in the wrong forum.
This forum, as the title says, is for 'SQL Developer (Not for general SQL/PL/SQL questions).
I'm doing a sp that returns me the value of a variable, then an update, but does not work when I add the output parameter
And it won't work - you added an 'output' parameter. But then this code tries to use it as if it were an 'input' parameter
You can only assign to output parameters; you cannot read them.
UPDATE tbl_Consecutivo SET consecutivo = AUXI
1. Define a variable
2. Select into the variable
3. UPDATE using the variable
4. Assign the variable to the output parameter
This is the WRONG forum. Please mark this question ANSWERED.
If you need any help other than the above repost the question in the SQL and PL/SQL forum.