This week's book giveaway is in the HTML Pages with CSS and JavaScript forum.
We're giving away four copies of Testing JavaScript Applications and have Lucas da Costa on-line!
See this thread for details.
Win a copy of Testing JavaScript Applications this week in the HTML Pages with CSS and JavaScript forum!

Remar Uy

Ranch Hand
+ Follow
since Mar 18, 2002
Cows and Likes
Cows
Total received
0
In last 30 days
0
Total given
0
Likes
Total received
0
Received in last 30 days
0
Total given
0
Given in last 30 days
0
Forums and Threads
Scavenger Hunt
expand Ranch Hand Scavenger Hunt
expand Greenhorn Scavenger Hunt

Recent posts by Remar Uy

Hi Eyad,

You have to start the OC4J Instance.

Hth,
Remar
15 years ago
Hi Siva,

Please check Oracle docs for the error cause. Maybe your Oracle session was killed.

Hth,
Remar
15 years ago
Jackie,
AFAIK, you can't declare a database column as boolean, but can use boolean datatype when declaring variables in PL/SQL.
Hth,
Remar
17 years ago
Congratulations Shan!
[ June 29, 2003: Message edited by: Remar Uy ]
17 years ago
It's 20% discount, iirc.
17 years ago
Sunitha,
One advantage of separating the package specs from the package body file is when you're running multiple package scripts, invalid reference error could be avoided. Suppose we have two package X and Y. Package X references Y. If we have only one file for both body and spec (X.sql and Y.sql), we have to run the Y.sql first before X.sql or else will have an invalid reference error. But it we separate the package spec and body files, we can run the specs file first (X_spec.sql and Y_spec.sql in any order) without considering the reference. Running the X_body.sql and Y_body.sql would then be reference error free since the specifications has been declared.
Hth,
Remar
17 years ago
Aakash,
Your data in the audit log would be rolled back. But if you want the audit log to be committed even the insert/update of the table fails, you can use autonomous transaction pragma, if you're using Oracle8i or above.
Hth,
Remar
[ June 25, 2003: Message edited by: Remar Uy ]
[ June 25, 2003: Message edited by: Remar Uy ]
17 years ago
Congratulations!
17 years ago
I tried the function in 8.1.7.0.0 and it results to:
17 years ago
Hi Rahul,
Remove the DECLARE keyword:

Since this is a procedure and not a function, you have to assign the 'success' and 'failure' to the 'x' variable.
But, I think a function would be more appropriate, returning a boolean:

Hth,
Remar
17 years ago
Hi Praveen,
You can check them out at Oracle Cert page.
Hth,
Remar
17 years ago
TrySTS.
I messed up the previous post.
17 years ago