A friendly place for programming greenhorns!
Big Moose Saloon
Register / Login
how to use userdefined datatype in Oracle 8i
Joined: Mar 30, 2009
Sep 17, 2009 08:25:37
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?
Joined: Jan 24, 2006
Oct 01, 2009 16:43:45
it ran ok on 11i after putting a ';' after your end statement. Not sure why it would not run if 8i supports object types.
Did you see how Paul
cut 87% off of his electric heat bill with 82 watts of micro heaters
subject: how to use userdefined datatype in Oracle 8i
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
All times are in JavaRanch time: GMT-6 in summer, GMT-7 in winter
| Powered by
Copyright © 1998-2014