What is the output statement in PostgreSQL

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • ashokakr
    New Member
    • Jul 2007
    • 7

    #1

    What is the output statement in PostgreSQL

    Hi all

    [CODE=sql]
    declare
    cnt integer;
    begin
    cnt=5;
    dbms_output.put _line(cnt);
    end;
    [/CODE]

    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.
  • michaelb
    Recognized Expert Contributor
    • Nov 2006
    • 534

    #2
    In a function you can use RAISE NOTICE for tracing,
    see Errors and Messages and Control structures for details.

    Comment

    Working...