Oracle Community Directory
Oracle Community FAQ
My Oracle Support Community (MOSC)
Go Directly To
Oracle Technology Network Community
My Oracle Support Community
OPN Cloud Connection
Oracle Employee Community
Oracle User Group Community
OTN Speaker Bureau
Please enter a title.
You can not post a blank message. Please type your message and try again.
Oracle Database + Options
This discussion is archived
on Nov 30, 2009 11:42 PM by 701859
Nov 30, 2009 11:25 PM
Hi guys, i want create and use a static procedure, but i have a
'ORA-04063: type body "A.TRATTA_TY" has errors'
'ORA-06508: PL/SQL:could not find program unit being called'
when I execute
Type ed procedure definition is listed below:
CREATE TYPE TRATTA_TY AS OBJECT
STATIC PROCEDURE n(p1 VARCHAR2,a1 VARCHAR2, km1 NUMBER)
CREATE TABLE TRATTA_TAB OF TRATTA_TY;
CREATE TYPE BODY TRATTA_TY AS STATIC PROCEDURE n(p1 VARCHAR2, a1 VARCHAR2,km1 NUMBER ) IS
INSERT INTO TRATTA_TAB VALUES(tratta_ty(p1, a1, km1));
Edited by: user10877806 on 30-nov-2009 13.07
Edited by: user10877806 on 30-nov-2009 13.56
Edited by: user10877806 on 30-nov-2009 15.25
I have the same question
Show 0 Likes
This content has been marked as final.
Show 1 reply
Re: STATIC METHODS
Nov 30, 2009 11:42 PM
in response to
Solved Thanks (I just deleted all and execute my code another time(boh :-))!