PC SOFT

PROFESSIONAL NEWSGROUPS
WINDEV, WEBDEV and WINDEV Mobile

Home | Recent messages | Connect |  | English US
Home → WINDEV 2024 → Native Oracle Access - Code in Calling Store Procedure
Native Oracle Access - Code in Calling Store Procedure
Started by Jospehine, Nov., 03 2005 5:05 AM - No answer
#1
Posted on November, 03 2005 - 5:05 AM
Hi,

I have a store procedure defined as :
PROCEDURE GetAll(nParamter1 IN NUMBER, curResult IN OUT LibCursor.General)

which will return result set by curResult.

I have no idea about the coding to call this procedure. What I written is:

sSql is string
sQuery is data source
sSql = "begin :res := GetAll(123); end;"
nResult = HExecuteSQLQuery(sQuery,connectName,hQueryWithoutCorrection,sSql)

With error :
native ORACLE access error
Error Number = 1007

ORA-01036: illegal variable name/number

Thanks in advance.

Josephine
→ Go back to WINDEV 2024