q: gupta calling oracle stored procedure with default value

From: iyi <iyi_at_sbk-ks.de>
Date: 1996/01/22
Message-ID: <4e0c99$lto_at_news.sbk-ks.de>#1/1


Using the following code segment in my application causes the following error messages

Has anyone a solution for this problem ?

thanks in advance

ibrahim

PL/SQL:

        create or replace procedure example 
                (val1 in number,
                 val2 in char default 'abc',
                 val3 in char default 'defaultvalue'   )
        as
        begin

....
end; SQLWindows:
..
Set strProc = 'example(val1, val3 => 'new value')' Call SqlPLSQLCommand (hSqlWork, strProc)
..
Error Messages: 1. Invalid Expression 2. Illegal PL/SQL datatyp 1, parameter #1
Received on Mon Jan 22 1996 - 00:00:00 CET

Original text of this message