Home » SQL & PL/SQL » SQL & PL/SQL » "wrap utility" & "function" topics merged
"wrap utility" & "function" topics merged [message #385289] Mon, 09 February 2009 00:24 Go to next message
rajasekhar857
Messages: 500
Registered: December 2008
Senior Member
hi,
iam getting the errors while compiling and executing the oracle 10g wrapped code.but it is working fine with 9i and below.
while dynamically declaring the exceptions resulted like
'select count(column name) from table name'

BEGIN IF(0=VWIsExists('Select Count(TName) From tab Where TName =' ||CHR(39) || 'DISPOSALACTIONLOOKUP' || CHR(39))) THEN
EXECUTE IMMEDIATE('CREATE Table DisposalActionLookUp

exception shows like
Count(TName) ==> ORA-06550: line 1, column 12:
PLS-00905: object ROOM_2010.VWISEXISTS is invalid
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored

please help me how to avoid it.
Re: wrap utility [message #385293 is a reply to message #385289] Mon, 09 February 2009 00:28 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Copy and paste EXACTLY what you did.
Before read OraFAQ Forum Guide, especially "How to format your post?" section.
Make sure that lines of code do not exceed 80 characters when you format.
Indent the code (See SQL Formatter), use code tags.
Use the "Preview Message" button to verify.
Also always post your Oracle version (4 decimals).

Regards
Michel
Re: wrap utility [message #385295 is a reply to message #385293] Mon, 09 February 2009 00:30 Go to previous messageGo to next message
rajasekhar857
Messages: 500
Registered: December 2008
Senior Member
ok iam sorry for that can you tell me what happend exactly for getting the above exceptions
Re: wrap utility [message #385299 is a reply to message #385295] Mon, 09 February 2009 00:40 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
Copy and paste EXACTLY what you did.

Regards
Michel
Re: wrap utility [message #385310 is a reply to message #385299] Mon, 09 February 2009 01:12 Go to previous messageGo to next message
rajasekhar857
Messages: 500
Registered: December 2008
Senior Member
what the reason for getting the exception in it i am unable to find.can anyone get it?
Re: wrap utility [message #385318 is a reply to message #385310] Mon, 09 February 2009 01:39 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Michel Cadot wrote on Mon, 09 February 2009 07:40
Quote:
Copy and paste EXACTLY what you did.

Regards
Michel

What is the reason for you to NOT post what I asked?

Regards
Michel

Re: wrap utility [message #385327 is a reply to message #385318] Mon, 09 February 2009 02:20 Go to previous messageGo to next message
rajasekhar857
Messages: 500
Registered: December 2008
Senior Member
CREATE OR REPLACE PACKAGE ViewWisePackage wrapped
a000000
b2
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
9
b0 ba
cmVKZ8aVqQFDufLLZMR0EZ9CSFUwg5m49TOf9b9c59lZYihyVtyyWln/3FmuXLh0K4+e9HSm
8jBFQAcSOZjUmDpTFjA51Ta+e/hbvhYRqVM4SjX/HEo1YKsbOTk57Ow8EXtuhNap4S8uSJ5n
h0uqL8iI06tdB+BWnxBATas7vnFzcdiIpiFvfFE=

/
Insert Into VWVerRev(Name,Type,Version,Revision) Values('VWIsExists',2,'6.0','0')
/
CREATE OR REPLACE FUNCTION VWIsExists wrapped
a000000
b2
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
8
ff f3
eLrxP4l9KOW77VNz45ITSxiTO3kwgwLcf9PWfHQeq4fu82GHsVlI4PK53e7TW7R1WClQwXj7
4vYfBcIU2Xng7/+CWQMFKQPNu+0cf48vOBVwe3TQOeGhnnRKRHwr8hFSzMNARSMl2VJj4ugR
qLdG3bIdkwfmsS3odQBu3BDnsvBsV3InueM3cyfMuHkQ4Jnx6gIJF58QINL7rYHt+ULPpwLO
rll+x+1TTgJWFgUFHy6tepc=

/
Insert Into VWVerRev(Name,Type,Version,Revision) values('DISPOSALACTIONLOOKUP',0,'6.0','0')
/
BEGIN IF(0=VWIsExists('Select Count(TName) From tab Where TName =' ||CHR(39) || 'DISPOSALACTIONLOOKUP' || CHR(39))) THEN
EXECUTE IMMEDIATE('CREATE Table DisposalActionLookUp
(
DisposalActionid NUMBER(10,0) NOT NULL,
Description VARCHAR2(255) NOT NULL
)');
END IF;
END;
/
ALTER Table DisposalActionLookUp ADD CONSTRAINT DisposalActionLookUp_id PRIMARY KEY (DisposalActionid)
/
Insert Into VWVerRev(Name,Type,Version,Revision) values('DOCTYPERETENTIONSETTING',0,'6.0','0')
/
BEGIN IF(0=VWIsExists('Select Count(TName) From tab Where TName =' ||CHR(39) || 'DOCTYPERETENTIONSETTING' || CHR(39))) THEN
EXECUTE IMMEDIATE('CREATE Table DoctypeRetentionSetting
(
id NUMBER(10,0) NOT NULL ,
DocTypeid NUMBER(10,0) NOT NULL ,
EnableRetention NUMBER(10,0) NOT NULL ,
RetentionPeriod NUMBER(10,0) NOT NULL ,
RetentionPeriodStartsid NUMBER(10,0) NOT NULL ,
DisposalActionid NUMBER(10,0) NOT NULL ,
MoveDocLocation VARCHAR2(255) NOT NULL ,
PolicyCreatedDate VARCHAR2(35) NOT NULL
)');
END IF;
END;
/
ALTER Table DoctypeRetentionSetting ADD CONSTRAINT FK_DisposalActionLookup_id FOREIGN Key (DisposalActionid) REFERENCES DisposalActionLookup(DisposalActionid) ON DELETE CASCADE
/
Insert Into VWVerRev(Name,Type,Version,Revision) values('ARSPROCESSEDDOCS',0,'6.0','0')
/
BEGIN IF(0=VWIsExists('Select Count(TName) From tab Where TName =' ||CHR(39) || 'ARSPROCESSEDDOCS' || CHR(39))) THEN
EXECUTE IMMEDIATE('CREATE Table ARSProcessedDocs
(
id NUMBER(10,0) NOT NULL ,
Docid NUMBER(10,0) NOT NULL ,
UserName VARCHAR2(50) NOT NULL ,
ProcessedDate VARCHAR2(35) NOT NULL ,
SessionKey VARCHAR2(50) NOT NULL ,
LocationName VARCHAR2(50) NOT NULL ,
Type NUMBER(10,0) NOT NULL
)');
END IF;
END;
/


i am getting the exception as

Executing ViewWise SQL Objects:...292/1352
Count(TName) ==> ORA-06550: line 1, column 12:
PLS-00905: object ROOM_2010.VWISEXISTS is invalid
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored

Executing ViewWise SQL Objects:...
Count(TName) ==> ORA-06550: line 1, column 12:
PLS-00905: object ROOM_2010.VWISEXISTS is invalid
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored

Executing ViewWise SQL Objects:...
Count(TName) ==> ORA-06550: line 1, column 12:
PLS-00905: object ROOM_2010.VWISEXISTS is invalid
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored

Executing ViewWise SQL Objects:...
Count(SEQUENCE_NAME) ==> ORA-06550: line 1, column 12:
PLS-00905: object ROOM_2010.VWISEXISTS is invalid
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored

Executing ViewWise SQL Objects:...302/1352
Count(SEQUENCE_NAME) ==> ORA-06550: line 1, column 12:
PLS-00905: object ROOM_2010.VWISEXISTS is invalid
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
Re: wrap utility [message #385329 is a reply to message #385327] Mon, 09 February 2009 02:27 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
1/ It is not formatted
2/ It is not what you did (ALL what you did), I din't you wrote
Quote:
CREATE OR REPLACE PACKAGE ViewWisePackage wrapped
a000000
b2
abcd
abcd

3/ The error "object ROOM_2010.VWISEXISTS is invalid" is quite clear, fix your object/type
4/ Use SQL*PLus and copy and paste your session, the WHOLE session
5/ "show errors" may help

Regards
Michel
Re: wrap utility [message #385356 is a reply to message #385329] Mon, 09 February 2009 04:29 Go to previous messageGo to next message
rajasekhar857
Messages: 500
Registered: December 2008
Senior Member
1)initially i created a package


CREATE OR REPLACE PACKAGE ViewWisePackage AS
TYPE ViewWise_Fld IS RECORD (Fld VARCHAR2);
TYPE ViewWise_CurTyp IS REF CURSOR RETURN ViewWise_Fld;
TYPE ViewWise_CurTyp1 IS REF CURSOR;
END;
/

2)next i have created a function

CREATE OR REPLACE FUNCTION VWIsExists(PARAMS VARCHAR2) RETURN INT As
TExist INT;
begin
BEGIN
EXECUTE IMMEDIATE(PARAMS) INTO TExist;
EXCEPTION
WHEN NO_DATA_FOUND THEN
RETURN(0);
NULL;
WHEN OTHERS THEN
RETURN(0);
NULL;
END;
RETURN(TExist);
end;
/


3)then given the code like this

BEGIN IF(0=VWIsExists('Select Count(TName) From tab Where TName =' ||CHR(39) || 'DISPOSALACTIONLOOKUP' || CHR(39))) THEN
EXECUTE IMMEDIATE('CREATE Table DisposalActionLookUp
(
DisposalActionid NUMBER(10,0) NOT NULL,
Description VARCHAR2(255) NOT NULL
)');
END IF;
END;
/
ALTER Table DisposalActionLookUp ADD CONSTRAINT DisposalActionLookUp_id PRIMARY KEY (DisposalActionid)
/
Insert Into VWVerRev(Name,Type,Version,Revision) values('DOCTYPERETENTIONSETTING',0,'6.0','0')
/
BEGIN IF(0=VWIsExists('Select Count(TName) From tab Where TName =' ||CHR(39) || 'DOCTYPERETENTIONSETTING' || CHR(39))) THEN
EXECUTE IMMEDIATE('CREATE Table DoctypeRetentionSetting
(
id NUMBER(10,0) NOT NULL ,
DocTypeid NUMBER(10,0) NOT NULL ,
EnableRetention NUMBER(10,0) NOT NULL ,
RetentionPeriod NUMBER(10,0) NOT NULL ,
RetentionPeriodStartsid NUMBER(10,0) NOT NULL ,
DisposalActionid NUMBER(10,0) NOT NULL ,
MoveDocLocation VARCHAR2(255) NOT NULL ,
PolicyCreatedDate VARCHAR2(35) NOT NULL
)');
END IF;
END;
/
ALTER Table DoctypeRetentionSetting ADD CONSTRAINT FK_DisposalActionLookup_id FOREIGN Key (DisposalActionid) REFERENCES DisposalActionLookup(DisposalActionid) ON DELETE CASCADE
/
Insert Into VWVerRev(Name,Type,Version,Revision) values('ARSPROCESSEDDOCS',0,'6.0','0')
/
BEGIN IF(0=VWIsExists('Select Count(TName) From tab Where TName =' ||CHR(39) || 'ARSPROCESSEDDOCS' || CHR(39))) THEN
EXECUTE IMMEDIATE('CREATE Table ARSProcessedDocs
(
id NUMBER(10,0) NOT NULL ,
Docid NUMBER(10,0) NOT NULL ,
UserName VARCHAR2(50) NOT NULL ,
ProcessedDate VARCHAR2(35) NOT NULL ,
SessionKey VARCHAR2(50) NOT NULL ,
LocationName VARCHAR2(50) NOT NULL ,
Type NUMBER(10,0) NOT NULL
)');
END IF;
END;
/
BEGIN IF(0=VWIsExists('Select Count(SEQUENCE_NAME) From user_sequences Where sequence_name=' ||CHR(39) || 'SEQ_PROCESSEDDOCS_ID' || CHR(39))) THEN
EXECUTE IMMEDIATE('CREATE SEQUENCE SEQ_PROCESSEDDOCS_ID
INCREMENT BY 1
START WITH 1
MAXVALUE 999999999
MINVALUE 1
ORDER
CYCLE
CACHE 20');
END IF;
END;
/


after i have wrapped the code like
wrap iname=orascipt.ora oname=orascript.plb

then while compiling and excecuting the errors are like

Count(TName) ==> ORA-06550: line 1, column 12:
PLS-00905: object ROOM2011.VWISEXISTS is invalid
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored

Executing ViewWise SQL Objects:...
Count(TName) ==> ORA-06550: line 1, column 12:
PLS-00905: object ROOM2011.VWISEXISTS is invalid
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored

Executing ViewWise SQL Objects:...
Count(TName) ==> ORA-06550: line 1, column 12:
PLS-00905: object ROOM2011.VWISEXISTS is invalid
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored

Executing ViewWise SQL Objects:...
Count(SEQUENCE_NAME) ==> ORA-06550: line 1, column 12:
PLS-00905: object ROOM2011.VWISEXISTS is invalid
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored

Executing ViewWise SQL Objects:...302/1352
Count(SEQUENCE_NAME) ==> ORA-06550: line 1, column 12:
PLS-00905: object ROOM2011.VWISEXISTS is invalid
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored

i have given everything in a clear manner then why it is happening like this?



Re: wrap utility [message #385370 is a reply to message #385356] Mon, 09 February 2009 05:32 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You still didn't post what I asked and how I asked it.

Regards
Michel
function [message #385493 is a reply to message #385289] Mon, 09 February 2009 22:54 Go to previous messageGo to next message
rajasekhar857
Messages: 500
Registered: December 2008
Senior Member
i am using the earlier code like this

CREATE OR REPLACE FUNCTION VWIsExists(PARAMS VARCHAR2) RETURN INT As
TExist INT;
begin
BEGIN
EXECUTE IMMEDIATE(PARAMS) INTO TExist;
EXCEPTION
WHEN NO_DATA_FOUND THEN
RETURN(0);
NULL;
WHEN OTHERS THEN
RETURN(0);
NULL;
END;
RETURN(TExist);
end;
/

now can i write the above code in the following manner

CREATE OR REPLACE FUNCTION VWISEXISTS(P_CUR IN SYS_REFCURSoR,PARAMS VARCHAR2)
RETURN INT
IS
TExist int;
Cursor P_CURSOR IS SELECT Params into texist from dual;
BEGIN
OPEN P_CURSOR;
LOOP
FETCH P_CURSOR INTO TEXIST;
DBMS_OUTPUT.PUT_LINE('NO OF ROWS ARE:' || P_CURSOR%ROWCOUNT);
EXIT WHEN P_CURSOR%ROWCOUNT>=&N;
END LOOP;
CLOSE P_CURSOR;
RETURN(TExist);
END;
/

iam getting exceptions is there any wrong in it.
Re: function [message #385495 is a reply to message #385493] Mon, 09 February 2009 22:57 Go to previous messageGo to next message
trivendra
Messages: 208
Registered: October 2007
Location: Noida, India
Senior Member
And what is the ERROR?
Re: function [message #385496 is a reply to message #385493] Mon, 09 February 2009 22:58 Go to previous messageGo to next message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
>iam getting exceptions
Exceptions? What exceptions? I don't see any problem.

You need to help us by following the Posting Guidelines as stated below.
http://www.orafaq.com/forum/t/88153/0/
So we can help you
Re: function [message #385499 is a reply to message #385496] Mon, 09 February 2009 23:09 Go to previous messageGo to next message
rajasekhar857
Messages: 500
Registered: December 2008
Senior Member
now i have written the code like this
SQL> CREATE OR REPLACE FUNCTION VWISEXISTS(PARAMS VARCHAR2)
2 RETURN INT
3 IS
4 TExist int;
5 Cursor P_CURSOR IS SELECT Params into texist from dual;
6 BEGIN
7 OPEN P_CURSOR;
8 LOOP
9 FETCH P_CURSOR INTO Texist;
10 DBMS_OUTPUT.PUT_LINE('NO OF ROWS ARE:' || P_CURSOR%ROWCOUNT);
11 EXIT WHEN P_CURSOR%ROWCOUNT>=&N;
12 END LOOP;
13 CLOSE P_CURSOR;
14 RETURN(TExist);
15 END;
16 /
Enter value for n: 5
old 11: EXIT WHEN P_CURSOR%ROWCOUNT>=&N;
new 11: EXIT WHEN P_CURSOR%ROWCOUNT>=5;

Function created.

SQL> BEGIN IF(0=VWIsExists('Select Count(TName) From tab Where TName =' ||CHR(39) || 'DISPOSALACTION
LOOKUP' || CHR(39))) THEN
2 EXECUTE IMMEDIATE('CREATE Table DisposalActionLookUp
3 (
4 DisposalActionid NUMBER(10,0) NOT NULL,
5 Description VARCHAR2(255) NOT NULL
6 )');
7 END IF;
8 END;
9 /
BEGIN IF(0=VWIsExists('Select Count(TName) From tab Where TName =' ||CHR(39) || 'DISPOSALACTIONLOOKU
*
ERROR at line 1:
ORA-06502: PL/SQL: numeric or value error: character to number conversion error
ORA-06512: at "ROOM2011.VWISEXISTS", line 9
ORA-06512: at line 1
Re: function [message #385528 is a reply to message #385499] Tue, 10 February 2009 00:51 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
You select a string (PARAMS) into an int (Texist).

Where did you get the idea that an execute immediate and a select into are interchangeable?

[Updated on: Tue, 10 February 2009 00:52]

Report message to a moderator

Re: function [message #385530 is a reply to message #385493] Tue, 10 February 2009 00:55 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
From your previous topic:
Michel Cadot wrote on Mon, 09 February 2009 07:28
Copy and paste EXACTLY what you did.
Before read OraFAQ Forum Guide, especially "How to format your post?" section.
Make sure that lines of code do not exceed 80 characters when you format.
Indent the code (See SQL Formatter), use code tags.
Use the "Preview Message" button to verify.
Also always post your Oracle version (4 decimals).

Regards
Michel

Which the same one than this one, so I merged one and the following is still true:
Michel Cadot wrote on Mon, 09 February 2009 12:32
You still didn't post what I asked and how I asked it.

Regards
Michel



[Updated on: Tue, 10 February 2009 01:00]

Report message to a moderator

Re: function [message #385609 is a reply to message #385530] Tue, 10 February 2009 04:31 Go to previous messageGo to next message
rajasekhar857
Messages: 500
Registered: December 2008
Senior Member
has to be changed to 2 in that format
1)CREATE OR REPLACE FUNCTION VWIsExists(PARAMS VARCHAR2)
RETURN INT
As TExist INT;
begin
BEGIN
EXECUTE IMMEDIATE(PARAMS) INTO TExist;
EXCEPTION
WHEN NO_DATA_FOUND THEN
RETURN(0);
NULL;
WHEN OTHERS THEN
RETURN(0);
NULL;
END;
RETURN(TExist);
end;

/
2)CREATE OR REPLACE FUNCTION concatenate_list (p_cursor IN SYS_REFCURSOR,
POperator VARCHAR2)
RETURN VARCHAR2 IS
l_return VARCHAR2(32767);
l_temp VARCHAR2(32767);
BEGIN
LOOP
FETCH p_cursor INTO l_temp;
EXIT WHEN p_cursor%NOTFOUND;
l_return := Ltrim(Rtrim(l_return)) || POperator || l_temp;
END LOOP;
RETURN LTRIM(l_return, POperator);
END;
/
Re: function [message #385611 is a reply to message #385609] Tue, 10 February 2009 04:34 Go to previous messageGo to next message
rajasekhar857
Messages: 500
Registered: December 2008
Senior Member
i am unable to format my code very sorry for this time too.
Re: function [message #385627 is a reply to message #385609] Tue, 10 February 2009 05:28 Go to previous messageGo to next message
S.Rajaram
Messages: 1027
Registered: October 2006
Location: United Kingdom
Senior Member
Quote:

i am unable to format my code very sorry for this time too


I am unable to understand your question. Very sorry for this time.

Regards

Raj
Re: function [message #385656 is a reply to message #385627] Tue, 10 February 2009 07:31 Go to previous messageGo to next message
ramoradba
Messages: 2454
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
Quote:
Michel Cadot wrote on Mon, 09 February 2009 07:28
Copy and paste EXACTLY what you did.
Before read OraFAQ Forum Guide, especially "How to format your post?" section.
Make sure that lines of code do not exceed 80 characters when you format.
Indent the code (See SQL Formatter), use code tags.
Use the "Preview Message" button to verify.
Also always post your Oracle version (4 decimals).

Regards
Michel





S.Rajaram wrote on Tue, 10 February 2009 05:28
Quote:

i am unable to format my code very sorry for this time too


I am unable to understand your question. Very sorry for this time.

Regards

Raj



As mentioned above,USE code tags to format your query.Please read OraFAQ Forum Guide. and as michel said,
Quote:
Copy and paste EXACTLY what you did.
.and also give us specific information like OS,DB version

[Updated on: Tue, 10 February 2009 07:31]

Report message to a moderator

Re: function [message #385769 is a reply to message #385656] Tue, 10 February 2009 23:54 Go to previous messageGo to next message
rajasekhar857
Messages: 500
Registered: December 2008
Senior Member
will oracle 10g wrap utility supports dynamic declarations.
because in 9i its working all the where but in 10g its throwing exceptions while declaring dynamically.
the below piece of code throwing when using with a function call
through a anonymous block

BEGIN
IF(0=VWIsExists('Select Count(TName) From tab Where TName ='||CHR(39) || 'DISPOSALACTIONLOOKUP' || CHR(39))) THEN
EXECUTE IMMEDIATE('CREATE Table DisposalActionLookUp
(
DisposalActionid NUMBER(10,0) NOT NULL,
Description VARCHAR2(255) NOT NULL
)');
END IF;
END;
/
Re: function [message #385778 is a reply to message #385769] Wed, 11 February 2009 00:42 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Still not posting what we ask, in the way we ask.
Do you really want help and answers?

Regards
Michel
Re: function [message #385802 is a reply to message #385778] Wed, 11 February 2009 02:00 Go to previous message
ramoradba
Messages: 2454
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
Quote:
Quote:
Michel Cadot wrote on Mon, 09 February 2009 07:28
Copy and paste EXACTLY what you did.
Before read OraFAQ Forum Guide, especially "How to format your post?" section.
Make sure that lines of code do not exceed 80 characters when you format.
Indent the code (See SQL Formatter), use code tags.
Use the "Preview Message" button to verify.
Also always post your Oracle version (4 decimals).

Regards
Michel





If you are unable to read the forum guide,we cannot help you.atleast follow the links and read about wrap utillity.

http://download.oracle.com/docs/cd/B19306_01/appdev.102/b14261.pdf

http://www.oracle-base.com/articles/10g/WrapAndDBMS_DDL_10gR2.php

[Updated on: Wed, 11 February 2009 02:01]

Report message to a moderator

Previous Topic: locking
Next Topic: How to Write a Timer Trigger (merged)
Goto Forum:
  


Current Time: Sat Dec 10 19:01:06 CST 2016

Total time taken to generate the page: 0.12288 seconds