PC SOFT

FORUMS PROFESSIONNELS
WINDEV, WEBDEV et WINDEV Mobile

Accueil  |  Messages récents  | Connexion  |   | Français  FR
Accueil → WINDEV 2024 → Native Oracle Access - Code in Calling Store Procedure
Native Oracle Access - Code in Calling Store Procedure
Débuté par Jospehine, 03 nov. 2005 05:05 - Aucune réponse
#1
Posté le 03 novembre 2005 - 05:05
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
→ Revenir à WINDEV 2024