Recent content by moin73

We have a web application where user connect to the oracle db (10g). User are getting following error when they execute specific report (ACTUATE). Note: WEBLOGIC is connect to the oracle through JDBC. ORA-24323: value not allowed

It's resolved, appreciate your help. Thanks

Is there any way to optimize "dbms_obfuscation_toolkit" ? I am using this package to encrypt/decrypt a client id. A CLIENT table contains more than 10,000 rows and performance goes so down whenever I called this routine. Please advise. Regards

I am trying and getting following error msgs. ERROR: ORA-24338: statement handle not executed SP2-0625: Error printing variable "myrefc

My cursor is returning a value, how to display it with dbms_output.put_line command. I m getting followng error msgs ORA-24338 dbms_output.put_line(to_char(o_result_set_rc));

I have defined CURSOR variable as a OUTPUT parameter in procedure. How to call and display an output of cursor variable(SQL QUERY) from sql/plus ? Regards

Eventhough script is running and producing results. But it's very slow with thousand of rows. Is there any way to tune it ?

I need to know a solution for script, I posted earlier. Appreciate your help. Thanks

Thanks, appreciate your response with details. Actually, following is the script I m using to break company associate with respect to employee. CURSOR c1 IS SELECT a.employee_id, d.description, c.company_name TRIM (c.company_name) FROM...

How to get following output from following 3 tables ? customer_id company stocks 111 c11 s11 c12 s12 112 c13 s12 c11 s13 c14 s14 Table structure...

Thanks, You are right that was typo in my initial posted. I will post a result of my query. Regards

Is there any other database optimization tool available i.e. OEM to monitor database performance e.g CPU usage, SGA allocation, query taking high resources ? What system privilege / Role require for a normal db user to execute performing tool ? Regards

I did not get it. Please clarify in detail.

Following query is working fine individual, however if I joined this query with view (v_company_alias) system & performance goes down. How I can optimize this query, so I can achieve best performance, please advise me. Here is detail Thanks SELECT DISTINCT company.company_id...