By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
431,965 Members | 2,043 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 431,965 IT Pros & Developers. It's quick & easy.

What is the output statement in PostgreSQL

P: 7
Hi all

Expand|Select|Wrap|Line Numbers
  1. declare
  2. cnt integer;
  3. begin
  4. cnt=5;
  5. dbms_output.put_line(cnt);
  6. end;
This is my sample procedure, no return type.
when i execute this procedure it shows that
"Syntax error at or near 'dbms_output'"

can any one help me in this problem by giving the correct syntax for the
output statement.
Jul 26 '07 #1
Share this Question
Share on Google+
1 Reply

Expert 100+
P: 534
In a function you can use RAISE NOTICE for tracing,
see Errors and Messages and Control structures for details.
Aug 2 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.