PL/SQL :: How To Find Error In Pkg Creation

Apr 26, 2013

I have 30 packages to be created for a new user, i call in the execute_pkg.sql which creates all the 30 packages.

i use like this

sql> set echo on
sql> set spool execute_pkg_spool.txt
sql>@execute_pkg.sql
sql> spool off

My questions:

I find it difficult to figure out the which pkg was not created, at present the spool file is too big with the pkg code in it

create or replace package test1....
...
..
..

Warning: Package Body created with compilation errors.

i wanted the output like this

test1
Warning: Package Body created with compilation errors.

View 5 Replies


ADVERTISEMENT

PL/SQL :: How To Find Out Initial Date Of Creation Of Table

Nov 7, 2013

I have a table which contains some data. But we are dropped and recreated the same table several times. Now I wanted to know that when this table created initially. How to findout the date of creation(very first time). 

View 13 Replies View Related

Trigger Creation Error

Nov 28, 2012

I am getting error while creating a trigger. I am not yet find any wrong statement. See the following code and comments.

SQL> CREATE OR REPLACE TRIGGER shclog_in before update on shclog for each row
WHEN (to_number(new.MSGTYPE) = 210)
2 3 declare
4 PRAGMA AUTONOMOUS_TRANSACTION;
5 begin
6 insert into starcas.transaction_log values(:new.PAN,
[code].......

Warning: Trigger created with compilation errors.

SQL> show error
Errors for TRIGGER SHCLOG_IN:

LINE/COL ERROR
-------- -----------------------------------------------------------------
4/1 PL/SQL: SQL Statement ignored
4/21 PL/SQL: ORA-00942: table or view does not exist
SQL>

View 4 Replies View Related

Server Administration :: Db Creation Ctl Error?

Jun 10, 2010

It's been 2 days from now that I'm bugging with this kind of error in my manual dB creation. I used DBCA first but we had a default directory settings, that's why I resorted to create the db manually. The dB was already created and currently has a status of STARTED.. I cannot mount it due to this error:

SQL> startup nomount
ORACLE instance started.
Total System Global Area 247463936 bytes
Fixed Size 2235856 bytes
Variable Size 177840688 bytes

[code]....

View 3 Replies View Related

SQL & PL/SQL :: Nested Table Creation Error

Apr 12, 2010

I am getting compilation error when create nested table type depend on table structure

SQL> CREATE OR REPLACE TYPE typ$nttb$1 IS TABLE OF emp%rowtype
2 ;
3 /

Warning: Type created with compilation errors.

SQL> show error
Errors for TYPE TYP$NTTB$1:

LINE/COL ERROR
-------- -----------------------------------------------------------------
0/0 PL/SQL: Compilation unit analysis terminated
1/29 PLS-00329: schema-level type has illegal reference to SCOTT.EMP
SQL>

View 5 Replies View Related

SQL & PL/SQL :: Trigger Creation Error On Secured Environment

Jun 21, 2011

I have created a trigger in a different server and is working fine. But then when I implemented the same trigger in a different server (secured) then I'm encountering this error:

PLS-00049: bad bind variable

Below is the code for the trigger for reference:

create or replace
TRIGGER TRG_ROLE_RIGHT_HISTORY
BEFORE INSERT OR UPDATE OR DELETE ON MAS_BPI.LOS_SEC_ROLE_RIGHT_MAPPING
FOR EACH ROW
DECLARE

[code]....

View 17 Replies View Related

SQL & PL/SQL :: Table Creation - Facing Error ORA-02438?

Oct 18, 2012

i want to create a table to perform a task when i insert client account details in this table then check the account type is in(S,C,R) and balance should be also check when account type S then balance >=5000, account type C then balance >=10000 and account type R then balance >=5000 but when i run this query then facing error "ORA-02438: Column check constraint cannot reference other columns"

SQL> ed
Wrote file afiedt.buf

1 create table kcb_acc_tab
2 (
3 accno varchar2(20) constraint accno_pk primary key,
4 name varchar2(20) constraint name_nn not null
5 constraint name_chk check((substr(name,1,1) between 'A' and 'Z') and name=upper(name)),

[code]....

View 4 Replies View Related

Application Express :: 4.2 - EA Error During Workspace Creation?

Jun 25, 2012

I tried to create my EA workspace for APEX 4.2 and got the following Error.

ORA-20987: APEX - GET_BLOCK Error. - ORA-20001: Execution of the statement was unsuccessful. ORA-01653: unable to extend table APEX_040200.WWV_FLOW_PAGE_PLUGS by 1024 in tablespace APEX_REL42 <pre>declare s varchar2(32767) := null; l_clob clob; l_length number := 1; begin s := null; wwv_flow_api.create_page_plug ( p_id=> 6594522669003504543 + wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_page_id=> 0, p_plug_name=> 'Menu', p_region_name=&g

View 14 Replies View Related

Database Creation With DBCA Fails With Error?

Apr 8, 2013

While Creating database on AIX Machine using DBCA utility I am getting following error

Error Details:
-------------------------------------------------------------------------------------------------------------------
Allocating device....
Specifying datafiles...
Specifing datafiles...
Restoring ...

[code]....

View 2 Replies View Related

Server Administration :: Database Creation Manual Error

Sep 16, 2011

i am creating database manually in oracle 9i os version ibm-aix5.3 it showing following error

CREATE DATABASE "varathu"
*
ERROR at line 1:
ORA-01501: CREATE DATABASE failed
ORA-00200: controlfile could not be created
ORA-00202: controlfile: '/backup/varathu/control01.ctl'
ORA-27040: skgfrcre: create error, unable to create file
IBM AIX RISC System/6000 Error: 13: Permission denied

View 18 Replies View Related

Server Administration :: TNS Error - DBCA After Database Creation Script Complete

Aug 15, 2010

I'm getting a "TNS disconnect" after database creation script creation in DBCA. Haven't figured out what's going on. I'm attempting to create a 2nd database on one linux 64 server. I get all the way through DBCA, but it won't go the final mile. Any thoughts? I've tried setting the port to a different port from the existing LISTENER, creating a LISTENER2 and associating it with the 2nd instance.

View 1 Replies View Related

ASM Disk Groups Creation After ASM Instance Creation

Jul 9, 2012

During ASM Disk Groups creation after the ASM instance creation, receive the following error: Disk Group ORAASMGROUP2 already exists. Cannot be created again

The Grid infrastructure was deinstall one time and still the same issue.

View 4 Replies View Related

Forms :: How To Find Line Number Of Error In 6i

Jun 4, 2012

How to find the line number along with package name or procedure name (for ex. in Oracle 10g DBMS_UTILITY.FORMAT_ERROR_BACKTRACE ) where exactly error is coming in forms.There is plsql code written and while executing the code, ORA-01722: invalid number error is coming. For easy tracing the error, any way is there ?

I searched in Google before posting in this forum and found that ON-ERROR trigger if we write DBMS_ERROR_TEXT it will display the ling number along with package or procedure name. But it is not working and this is only giving me error name no line number.

View 3 Replies View Related

Backup & Recovery :: Error / (OS 3) The System Cannot Find The Path Specified

Jul 22, 2011

when i am running this syntax in rman i got this error so can you suggust me a correct syntax

Quote:

RMAN> run{
2> allocate channel c1 device type disk maxpiecesize 5m;
3> set backup copies = 2;
4> backup datafile 1 format 'E:
ol\%u_%c','E:
ol\%u_%c';
5> }

allocated channel: c1
channel c1: sid=142 devtype=DISK

executing command: SET BACKUP COPIES

Starting backup at 22-JUL-11
channel c1: starting full datafile backupset
channel c1: specifying datafile(s) in backupset
input datafile fno=00001 name=E:ORACLEPRODUCT10.2.0ORADATAORCLSYSTEM01.DBF

[code]...

View 7 Replies View Related

SQL & PL/SQL :: WEBADI Error ORA-06508 Could Not Find Program Unit Being Called

May 30, 2010

When I run my package in TOAD and SQL plus I am not getting any errors. My package is being compiled well. When I integrate my Package through WED ADI .I am getting the above error. I am new to oracle apps WEDADI. can any give your valuable sugessions. I have even bounched the apache two times.

The schema for my package is APPS. Can you tell us how to go check the schema of WEB ADI. We see my integrator created in BNE_INTEGRATORS_TL. Since it is store in BNE table, the schema for BNE table is 'BNE'?

How to provide the access of package to the WEB ADI?

View 1 Replies View Related

OPatch Commands Are Failing With Error Code 255 And Not Able To Find OUI Jars

Aug 21, 2013

I'm trying to apply a patch using opatch but I'm getting this error:

"OPatch was not able to find OUI jars to load them runtime. Please provide valid oui location using 'oui_loc' option. OPatch failed with error code 255". 

Oracle is 11.2.0.3 x64 on Windows Server 2008R2 x64. The PATH variable have

%ORACLE_HOME%OPatch, %ORACLE_HOME%OPatchjlib, %ORACLE_HOME%in in it. 

The only OPatch command that is working and not throwing the error  is the "opatch version" command. 

OPatch Version: 11.2.0.3.5 OPatch succeeded. 

No luck on finding issue resolution or documentation on MOS. I cannot find any documentation about the "oui_loc" option. 

View 10 Replies View Related

Precompilers, OCI & OCCI :: Error ID 0706-006 Cannot Find Or Open Library File

Apr 1, 2010

I have 3 code files written in ProC. I have precompiled, compiled, tested them in my local environment (Windows) & they work fine. But when I try in real environment, AIX 5.3, I can precompile them. But when I try to compile & link them with the libclntsh library I get errors. I am using a Makefile but just for testing this is the command -

xlc oraProcs oraProcs.c test_curva.c lib_util.c -I $ORACLE_HOME/precomp/public -L $LIBPATH -l libclntsh.a
Error - ld: 0706-006 Cannot find or open library file: -l libclntsh.a
ld: open(): A file or directory in the pathname does not exist

where LIBPATH = $ORACLE_HOME/lib

library libclntsh.a exists in $ORACLE_HOME/lib & has the right permissions

I also tried removing the library libclntsh.a & recreating it using the command - genclntsh When I run this command I get this warning more than once -ld: 0711-783 Warning TOC overflow TOC size: 66888 Max size: 65536 genclntsh creates the library libclntsh.a, just not sure if these warnings damage the library file and are related to my link erros in some way.

View 2 Replies View Related

DB Creation Manually?

Oct 19, 2012

Just started to learn oracle DBA. I am creating database manually.. I am facing following errors

I executed catproc.sql script it was running suddenlt oracle throwd following error.

CODEPL/SQL procedure successfully completed.
PL/SQL procedure successfully completed.
Package body created.

No errors.

Package body created.

BEGIN
*
ERROR at line 1:
ORA-01552: cannot use system rollback segment for non-system tablespace 'TEMP'
ORA-06512: at "SYS.DBMS_STATS", line 13210
ORA-06512: at "SYS.DBMS_STATS", line 13517

[code]...

Script detail's

CODECREATE  DATABASE drprod
       LOGFILE GROUP 1 ('/u01/app/oracle/oradata/drprod/redo01.log') SIZE 100M ,               GROUP 2 ('/u01/app/oracle/oradata/drprod/redo02.log') SIZE 100M
  MAXLOGFILES 5
  MAXLOGMEMBERS 5

[code]...

View 14 Replies View Related

SQL & PL/SQL :: Creation Of Package

Jan 12, 2011

Why Package has to be created as two parts

1) Package spec
2) Package Body ?
Quote:PLS-00304: cannot compile body of '<PACKAGE_NAME>' without its specification

I learned it as a Thumb of rule! But IF there is any rule for it give that URL/link for that.

View 25 Replies View Related

Index Creation Estimates

May 13, 2013

I have a quiet large table (around 140 GB) and i want to create an index on it. I was wondering, before i fire my my create index statement, i know in advance how long will it take to complete? I know after the create index is executed, we can monitor and gets some estimates from longops view. but is there any way we estimate before hand?

Also my database is in archive log mode and what would be the fastest way to create an online index?

View 5 Replies View Related

ASM Diskgroup Creation Failed

Apr 12, 2011

i am trying to create the ASM diskgroup means it's giving the below error.

[root@racdb3 ~]# /etc/init.d/oracleasm createdisk VOL1 /dev/sdb6
Marking disk "VOL1" as an ASM disk: [FAILED]

View 4 Replies View Related

Automatic User Creation

Apr 15, 2012

I am doing my master project on oracle Database. I need to create a PL/SQL script to create user automatecally. Name of the users i am supposed to get from some table (say pr_id of table persons).

View 4 Replies View Related

SQL & PL/SQL :: Creation Of Sequence To Varchar

Dec 7, 2011

how to create sequence to varchar and how see that sequence

View 2 Replies View Related

SQL & PL/SQL :: Parametrized Cursor Creation

Apr 26, 2012

I have a quick question, can we create a cursor as parametrized so that it picks up the table name as an input to the procedure, but it is not compiling.

CREATE OR REPLACE PROCEDURE CORPREPRECON.D_Q_CHECK_P (IN_TABLE_NAME IN VARCHAR2 )
IS
V_NULL_CHECK NUMBER(10) := 0;
V_BLANK_CHECK NUMBER(10) := 0;
V_LEN_CHECK NUMBER(10) := 0;
CURSOR C1 IS SELECT * FROM ||IN_TABLE_NAME;
[code]......

View 15 Replies View Related

SQL & PL/SQL :: New Table Creation From Different Databases?

Apr 9, 2013

I have two tables having same name in two different databases.i have to create a new table with these two tables in a new database.

But if one table have 2 columns and another table having three columns I have to create a new table with three columns..

View 6 Replies View Related

SQL & PL/SQL :: External Table Creation

May 23, 2011

i had small query on external tables. i had (.csv) file outside the database. In this file, one column will be added monthly. i need to create the external table dynamically by adding the column for every month.

How the procedure can be created for this requirement.

View 9 Replies View Related

PL/SQL :: Materialized View Creation?

Jun 15, 2013

I am running into an issue and trying to ascertain issue.  Scenario:I have 2 MV creation scripts. The MV is supposed to get populated by connection from schema to another schema USING DB Links.Basically, SAME HOST, SAME RAC DATABASE, just separate schemas.  The MV creations are just hanging. I see NO alert log mentions. I ran  a SQL trace and yes,

I see:  call count       cpu elapsed       disk query    current        rows------- ------  -------- ---------- ---------- ---------- ----------  ----------Parse 0      0.00 0.00 0          0 0           0Execute   1011 1.40 73.80 0 0 0           0Fetch 1010      1.08 317.57 0 0 0        1010------- ------  -------- ---------- ---------- ---------- ----------  ----------total 2021      2.49 391.38 0 0 0        1010 Misses in library cache during parse: 0Optimizer mode: ALL_ROWSParsing user id: 109     (recursive depth: 2) Elapsed times include waiting on following events:  Event waited on Times Max. Wait  Total Waited  ---------------------------------------- Waited  ----------  ------------  SQL*Net message to dblink 2022 0.00          0.00  SQL*Net message from dblink 2021 0.46        242.58    

Understandable, but when I do a selective query, the results come back pretty much within 5 seconds.DB version is 11.2.0.3.   Is there a BUG that I should know about?

 Here is a snippet:  

CREATE MATERIALIZED VIEW "SCHEMA"."MV_NAME_MV" USING INDEX REFRESH COMPLETE ON DEMAND AS (SELECT distinct mapguide_persons(pl.location_code) "FULL_NAME_COSTCENTER",mapguide_jobemp(pl.location_code) "TRUNCNAME_JOB",mapguide_empnum(pl.location_code) "FULLNAME_EMPNUMBER_PHONE",mapguide_english(pl.location_code)

[code]....

View 7 Replies View Related

SQL & PL/SQL :: Database Link Creation

Jan 28, 2013

I have installed oracle database 11gr2 in laptop1 and installed oracle database 11gr2 in laptop2.Both the laptop's are connected to same internet connection through wifi. So my question is can i create a database link between these two databases using this wifi? give some steps in creation of a database link.

View 13 Replies View Related

SQL & PL/SQL :: Empty Space Creation

May 29, 2013

While i am inserting data into a specific table that table assigns empty spaces.

For example:
CREATE TABLE DEALER_MST
("DEALER_CODE" CHAR(10) NOT NULL ENABLE,
"REGION_CODE" CHAR(3),
"SUB_REGION_CODE" CHAR(3),
"DEALER_NAME" VARCHAR2(80),

[Code]....

But it is giving result as DS with 8 spaces. It assigns spaces in db automatically while fetching.

View 8 Replies View Related

Adding Check After Table Creation

May 23, 2009

I created a table but I want to add the Unique check to it as I forgot to apply it to the table when I created it.Is it possible to make the field Unique after having created the table or do I have to drop the table and re-create it?

View 3 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved