Register / Login
Win a copy of
Functional Reactive Programming
this week in the
how to use userdefined datatype in Oracle 8i
posted 7 years ago
I have created user defined datatype in oracle 8i as seen below.
create or replace type Temp_TStrings as table of varchar2(4000); /
I want to use this variable in oracle 8i as seen below.
CREATE OR REPLACE function my_join ( p_cursor sys_refcursor, p_del varchar2 := ',' ) return varchar2 is strList Temp_TSTRINGS; begin strList := new Temp_TSTRINGS(); --- This is ORACLE 9i syntax. ( It is creating problem in 8i. How to do so in 8i?) - - - end /
how to use this user defined datatype in function in oracle 8i?
posted 6 years ago
it ran ok on 11i after putting a ';' after your end statement. Not sure why it would not run if 8i supports object types.
passing 2D arrays to Oracle Stored Procedure with/without using JPublisher
Testing a simple Oracle PL SQL function using toad sql client?
Oracle Java Stored Procedures