I'm new to Oracle, so I apologize for such a simple question, but I've already wasted several hours on it.
I have the following stored procedure:
create or replace procedure MyTestProc (outparam OUT VARCHAR2) AS begin select 'test' into outparam from dual; end;
How do I call this stored procedure, and insert the value of
outparam into a variable? I'd like to be able to do this so I can then use the result for other things, e.g., printing it to output.
Using functions, I was able to do this as easy as:
variable tmpString VARCHAR2(100); call MyTestFunc('test') INTO :tmpString; print tmpString;
How do I do this with stored procedures?