da-soft - Data Access Technologies

Additional

dbCAP

AnyDAC

ThinDAC

NCOCI8

Topic: TOCIProcedure with complex parameters

Forum List » NCOCI8 » General English

Mur
User

Platinum Boarder

Posts: 116

Karma: 0

TOCIProcedure with complex parameters

Posted: 2001/03/01 03:09

Hi Dmitry!
I need to call a PL/SQL procedure with 2 parameters. 1st is of type record and 2nd is of type table of records.
Both doesn't work

When assigning TOCIStoredProc.Name procedure with only 1st parameter, I get ORA-24334 Для этой позиции дескриптор не существует.
When assigning TOCIStoredProc.Name procedure with only 2nd parameter, I get NOE135/SP Параметр с типом TABLE OF BOOLEAN/RECORD не поддерживается (Используйте TOCIQuery)
NCOCI 0.9.2, Oracle server and client 8.1.6 for NT
Any suggestions?
(If possible, notify me by ICQ, because it is urgent)

Diman

Admin

Posts: 1509

Karma: 20

RE: TOCIProcedure with complex parameters

Posted: 2001/03/01 03:50

Hello !

1)Yes, you cant use stored procedure & TOCIStoredProc, when SP has parameter of type TABLE OF RECORD. Use TABLEs of scalar types: NUMBER, VARCHAR2, etc
2)ORA-24334. I cant say, when you can get such error. Could you send me demo ?

Regards,
Dmitry

Mur
User

Platinum Boarder

Posts: 116

Karma: 0

RE: TOCIProcedure with complex parameters

Posted: 2001/03/01 04:55

Test project sent by email

Forum List » NCOCI8 » General English