Re: Ansi SQL and stored procedures

Użytkownik tiz napisał:
> 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?
>

Q1:

'SELECT COUNT(*) FROM DUAL;' gives 1 row ?

Q2:

Does pl/sql block below run without error?

DECLARE   x VARCHAR2(4);
  y VARCHAR2(4):= 'aaa';

BEGIN   GetNomeFromCognome1(y, x);

END;
/

-- 
Noel