Devart Forums

Hi,

I'm trying to set a parameter of a type defined in a package. The type is one of "record". How can I use it? I'm attempting to create a TOraType, but it doesn't work:
OCI-22303: type "SYS"."DBMS_DEBUG"."PROGRAM_INFO" not found.


--
Martijn Tonies
Upscene Productions

OCI and Net do not support Oracle Record types, to use it you can do the following:
1- create PL/SQL block in which declare record variable
2- set variable fields with params
3- use this variable (insert in table, pass to storedproc etc)
and vice versa to read record data.

Duh. Who would have thought that.

Thanks, I'll try the workaround.

--
Martijn Tonies
Upscene Productions[/quote]