PC SOFT

GRUPOS DE DISCUSSÃO PROFISSIONAL
WINDEV, WEBDEV e WINDEV Mobile

Inicio | Mensagens recentes | Conecte-se... |  | Português FR
Inicio → WINDEV 2024 → Native Oracle Access - Code in Calling Store Procedure
Native Oracle Access - Code in Calling Store Procedure
Iniciado por Jospehine, nov., 03 2005 5:05 AM - Sem resposta
#1
Publicado em novembro, 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
→ Voltar para WINDEV 2024