| importing packages...! [message #135010] |
Mon, 29 August 2005 07:59  |
balavignesh
Messages: 180
Registered: March 2005
|
Senior Member |
|
|
hai all,
we need to import some packages from the export dump taken.the dump has 6 files of 2g each. is there any way to import only the needed packages from the export dump..? or we need to import the entire export dump...? plz help out...!
regards
bala
|
|
|
|
|
|
| Re: importing packages...! [message #135053 is a reply to message #135010] |
Mon, 29 August 2005 11:58  |
balavignesh
Messages: 180
Registered: March 2005
|
Senior Member |
|
|
hai mahesh,
thanks a lot.
while recreating package it was successfull but when creating the package body it gives that the "package body created with compilation errors as warning".how to resolve this..?
the following is the PL/SQL code
--------------------------------
create PACKAGE BODY pack_user AS
PROCEDURE PROC_SETUSERGRP(nGrpid LOOKUP_USERGRPS.grpid%TYPE,
sGrpname LOOKUP_USERGRPS.grpname%TYPE,
sActive LOOKUP_USERGRPS.active%TYPE)
IS
BEGIN
IF nGrpid IS NULL THEN
INSERT INTO Lookup_UserGrps VALUES (SEQ_LOOKUP_USERGRPS.NextVal, sGrpNam
e, PACK_UTILITY.f_getcurpracid, sActive);
ELSE
UPDATE Lookup_UserGrps SET Active = sActive WHERE Grpid = nGrpid;
END IF;
END;
END pack_user;
-----------------------------------------
help out..
bala
|
|
|
|
|
|
| Re: importing packages...! [message #135055 is a reply to message #135054] |
Mon, 29 August 2005 12:16 |
balavignesh
Messages: 180
Registered: March 2005
|
Senior Member |
|
|
SQL> show errors
Errors for PACKAGE BODY PACK_USER:
LINE/COL ERROR
-------- -----------------------------------------------------------------
8/9 PL/SQL: SQL Statement ignored
8/82 PL/SQL: ORA-00917: missing comma
|
|
|
|
| Re: importing packages...! [message #135056 is a reply to message #135055] |
Mon, 29 August 2005 12:25 |
 |
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
|
Senior Member
Account Moderator |
|
|
>>8/82 PL/SQL: ORA-00917: missing comma
You know what it means.
right?
May be this a mistake with your editor?
>> IF nGrpid IS NULL THEN
>>INSERT INTO Lookup_UserGrps VALUES (SEQ_LOOKUP_USERGRPS.NextVal, sGrpNam
>>e, PACK_UTILITY.f_getcurpracid, sActive);
it is supposed to be
IF nGrpid IS NULL THEN
INSERT INTO Lookup_UserGrps VALUES (SEQ_LOOKUP_USERGRPS.NextVal, sGrpName, PACK_UTILITY.f_getcurpracid, sActive);
[Updated on: Mon, 29 August 2005 12:25] Report message to a moderator |
|
|
|
| Re: importing packages...! [message #135058 is a reply to message #135056] |
Mon, 29 August 2005 12:52 |
balavignesh
Messages: 180
Registered: March 2005
|
Senior Member |
|
|
even after correcting it blows........!
create PACKAGE BODY pack_user AS
PACKAGE BODY pack_user IS
PROCEDURE PROC_SETUSERGRP(nGrpid LOOKUP_USERGRPS.grpid%TYPE,
sGrpname LOOKUP_USERGRPS.grpname%TYPE,
sActive LOOKUP_USERGRPS.active%TYPE)
IS
BEGIN
IF nGrpid IS NULL THEN
INSERT INTO Lookup_UserGrps VALUES (168,sGrpName,651,sActive);
ELSE
UPDATE Lookup_UserGrps SET Active = sActive WHERE Grpid = nGrpid;
END IF;
END;
-- Enter further code below as specified in the Package spec.
END pack_user;
-----------
LINE/COL ERROR
-------- -----------------------------------------------------------------
17/4 PLS-00103: Encountered the symbol "end-of-file" when expecting
one of the following:
begin end function package pragma procedure form
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
