Re: Calling Oracle Stored Procedures from Powerbuilder 3.0

al.davis_at_ns.sympatico.ca wrote:
>
> I am trying to call an Oracle stored procedure from an older version
> of Powerbuilder, 3.0d. I can not get past the Oracle error
> PLS-306 wrong number of types of arguments in call name. The
> Powerbuilder string variables have been assigned a value. The call
> to an Oracle procedure not passing any variables back works successfully.
>
> There are two in variables and two out variables. Powerbuilder does
> not appear to like the IN OUT declaration. The execution of
> the procedure complains about the third variable, which is the first
> out variable. Does anyone know the missing piece or have any ideas
> what to try?
>
> Regards,
>
> Al
>
> -------------------==== Posted via Deja News ====-----------------------
> http://www.dejanews.com/ Search, Read, Post to Usenet
Hi,

what I had t odo when calling SP's from VB is to enclose string-variables in quotes.

Declare szLclTest as String
Declare szLclSQL as String

	szLclSQL="BEGIN;SPTEST('" & szLclTest & "');END;"
	dbGblTest.Execute(szLclSQL)

-- 
Regards

Matthias Gresz    :-)