Save procedure code in a file called cbt_trig1.sql then wrap using the following command e:\raj\YKR_SQL>wrap iname=cbt_trig1.sql PL/SQL Wrapper: Release 10.1.0.2.0- Production on Fri Aug 07 16:58:27 2009 Copyright (c) 1993, 2004…
select trunc(trans_date),count(1) from htd_bill_master group by trunc(trans_date) order by trunc(trans_date); select trunc(trans_date),count(1) from htd_bill_master * ERROR at line 1: ORA-12801: error signaled in pa…
While using OUI it fails with following message, OUI-10020:The target area /oracle/10gR2/oraInventory is being used by another session. A write lock cannot be obtained. Action Cause of The Problem There is some process or so…
$ sqlplus "/as sysdba" SQL*Plus: Release 9.2.0.8.0 - Production on Fri Aug 14 17:05:02 2009 Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved. ERROR: ORA-09925: Unable to creat…