Using "type ... is record"

upscene · Post by **upscene** » Mon 30 May 2005 16:06

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

Alex · Post by **Alex** » Tue 31 May 2005 07:44

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.

upscene · Post by **upscene** » Tue 31 May 2005 12:56

Duh. Who would have thought that.

Thanks, I'll try the workaround.

--
Martijn Tonies
Upscene Productions[/quote]