Re: returning text at sql prompt from a procedure [message #7619] |
Wed, 25 June 2003 05:38 |
Suman Chattopadhyay
Messages: 9 Registered: June 2003
|
Junior Member |
|
|
Hi,
Thanks for your reply. I know that will work. But my requirement is to know whether it is possible from sql prompt or not,i. I shall not write that extra block of sql code. On ly the procedure and calling it from the prompt.
Hope u get my point.
Suman
|
|
|
Re: returning text at sql prompt from a procedure [message #7625 is a reply to message #7619] |
Wed, 25 June 2003 06:29 |
jigar
Messages: 74 Registered: July 2002
|
Member |
|
|
The numeric error was because u were not specifiying the size of the variable
Just specify the size
var ret varchar2 (10)
and write
exec outdata(:ret)
this will solve the numeric/value error.
but it will not print the :ret.
for this you can write DBMS_OUTPUT in the procedure as well and it will print the out parameter.
I think this will help you. Sorry if I misunderstood your question.
hope this
|
|
|