Re: Ansi SQL and stored procedures

From: tiz <tbezzi_at_yahoo.com>
Date: 28 Feb 2005 01:05:39 -0800
Message-ID: <1109581539.768328.98360_at_g14g2000cwa.googlegroups.com>


[Quoted] That's the stored proc statement:

PROCEDURE GetNomeFromCognome1(cognome VARCHAR2, nome OUT VARCHAR2) IS   BEGIN
        select 'aaa' into nome from dual ;   END; really simple, isn't it? So I think the problem is in the Proc code.

Could so show me where to find good documentation about dynamic sql? The ProC oracle manual is too simple. I could not find anywhere an example that's retrieves out params from a stored procedure.

When I call a stored proc with OUT params do I have to describe them in the input descriptor section?

thanx
tiz Received on Mon Feb 28 2005 - 10:05:39 CET

Original text of this message