-
Display data using PL/SQL Procedure
Is it possitble to display data on screen using a procedure.
I have a select statement which is parameterised.
I want to put this in a PL/SQL procedure.Which is fine to do have an IN paramater.
Is there any way to print the data on the screen after i execute the procedure.
Ex: SQL>execute proc_select(abc);
123 abc 8484 ndhjd
is there any way to do this.
plz help.
-
-
dbms_output has limitation i guess.
Any clue on what the limitation is.
-
255 characters in a single call
-
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|