Home » SQL & PL/SQL » SQL & PL/SQL » Need help understanding (Win 2003 8i, 9i, 10g)
Need help understanding [message #303686] Sun, 02 March 2008 00:28 Go to next message
durgadas.menon
Messages: 365
Registered: December 2007
Location: Nowhere
Senior Member
Hi,

I am working on restoring a database through import and came across scripts to create type which were used to create tables, here is a type script

CREATE TYPE U_USRCAT_TY
as object
(mmbrid_c ref u_usrreg_ty
,cat_n ref u_cathdr_ty
,subcat_n ref u_subcat_ty
,ownd_i char(1)
,plnd_i char(1)
,
static procedure p_usrcatinsert
(pownd_i char
,pplnd_i char
,sname_m varchar2
,tname_m varchar2
,tname1_m varchar2
,tname2_m varchar2
,tname3_m varchar2
,ref1val_x varchar2
,ref2val_n number
,ref3val_n number
)
)

then these scripts are used to create table like this

create table a of U_USRCAT_TY

I am unable to understand what does this "static procedure p_usrcatinsert" means in the type and what role will it play when the table is created with this type

- Das
Re: Need help understanding [message #303692 is a reply to message #303686] Sun, 02 March 2008 01:30 Go to previous message
Michel Cadot
Messages: 64117
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Almost 100 posts and still don't know how to post.
Edit your message and add formatting and code tags.

In addition, TYPEs are described in PL/SQL User's Guide and Reference and Application Developer's Guide - Fundamentals.

Regards
Michel
Previous Topic: How to sum formated numeric values
Next Topic: Select in trigger - strange NO_DATA_FOUND
Goto Forum:
  


Current Time: Tue Dec 06 02:52:00 CST 2016

Total time taken to generate the page: 0.04866 seconds