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
Messages: 365
Registered: December 2007
Location: Nowhere
Senior Member

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

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: 64418
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.

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

Current Time: Sun Feb 19 13:05:53 CST 2017

Total time taken to generate the page: 0.11799 seconds