Home » SQL & PL/SQL » SQL & PL/SQL » Displaying the Output from a variable in Stored procedure
icon4.gif  Displaying the Output from a variable in Stored procedure [message #425689] Sun, 11 October 2009 19:28 Go to next message
abhishek1234
Messages: 1
Registered: October 2009
Location: unites states
Junior Member

Can any one please let me know the command used to print the output
from a variable in sql tools 1.5
I am using DDBMS_OUTPUT.PUT_LINE('Data' || a);
but its not working its throws an error ORA-00900: invalid SQL statement.


Re: Displaying the Output from a variable in Stored procedure [message #425694 is a reply to message #425689] Sun, 11 October 2009 22:12 Go to previous message
BlackSwan
Messages: 24905
Registered: January 2009
Senior Member
> DDBMS_OUTPUT.PUT_LINE('Data' || a);

correct spelling MATTERS!
Previous Topic: View with params from user
Next Topic: Rebuilding Index
Goto Forum:
  


Current Time: Mon Sep 26 04:20:37 CDT 2016

Total time taken to generate the page: 0.23718 seconds