Trace Particular Object (procedure / Package) On Database?
Dec 13, 2012How do I trace an particular object (procedure/package) on the database. my database version is Oracle 11g(11.2.0.2)
View 2 Replies
ADVERTISEMENT
Application Express :: Creating Procedure Using Database Package
Oct 23, 2012I have created a procedure within a database package, but when I want to create a form based on procedure but I can't call it. I think that I have to use prefix, I am a beginner in database and I don't know how to do this.
View 4 Replies View RelatedSQL & PL/SQL :: Difference Between Object Type And Package
Oct 11, 2011understand between Oracle pl/sql object type and package!
View 3 Replies View RelatedPL/SQL :: ORA-22806 - Not Object Or REF When Using Record In Package?
Jun 19, 2013Oracle Database 11g Enterprise Edition Release 11.1.0.7.0
I have declared a record type in my package
create or replacePACKAGE MYPKG AS TYPE MYREC IS RECORD (VAL1 varchar2(20), val2 date); PROCEDURE display_error (pSQLERRM number); PROCEDURE P_LOAD_DATA (pStartDate Date, pEndDate Date); FUNCTION F_EPI(refno1 in NUMBER, refno2 in NUMBER) return
[code]...
SQL & PL/SQL :: Procedure Called To Trace
Jul 12, 2012I have a procedure in the live environment , which operate in 2 mode.
1 regular load at 10 min
2 nightly
The code is same except they set the last loaded time for both in 2 dfferent rows, so that next time run will get incremental data.
I can trace this procedure on mode 1 that is is scheduled but unable to find how the 2nd one is getting trigger every night. there is no jobs corresponding to that. Is there any way i can find which method is trigger the procedure during night.
SQL & PL/SQL :: Find And Trace Custom View / Procedure?
May 24, 2013I know that this query had been executed again the db, but the person is no longer here. Last run was about 3~4 months ago.
SELECT Subject_ID,
TO_CHAR (completed_date, 'mm/dd/yyyy'), status
FROM ADMINDBG_USER.adbt_master
...
[ADMINDBG_USER.adbt_master] is not a part of [dba_tables]. [ADMINDBG_USER.adbt_master] must be a view/procedure/a sort.
I have no luck to find what view/procedure/syntax is populating the data onto [ADMINDBG_USER.adbt_master].
PL/SQL :: Find Out In Database Package Where Package Is Installed
May 28, 2013I need to find out in DB Package where this Package is installed (in which schema). The problem is this DB Package can be installed in various schemas. This means that I can't use select user from dual or system environment SYS_CONTEXT('USERENV', 'OS_USER').
What I would need is something like $$PLSQL_UNIT
SQL & PL/SQL :: Two Different Package Can Contain Same Procedure?
Mar 31, 2011is it possible that two different package can contain same procedure?
View 1 Replies View RelatedSQL & PL/SQL :: Package And Procedure?
Jul 17, 2012In package specification, there 3 procedures But in package body, there are 2 procedures...will this execute?
View 14 Replies View RelatedForms :: How To Call Procedure From One To Another Object Library
Jan 29, 2013I have one procedure "PROC_A" in LibraryA, Is it possible to call this procedure PROC_A from LibraryB.
View 1 Replies View RelatedSQL & PL/SQL :: Check If Object Exist Or Not While Creating Procedure?
Mar 5, 2012I have to create a stored procedure having some 10 cursors and i have to display the data's fetched by select statement in cursors using dbms_output.put_line().
for ex:
-------
CREATE OR REPLACE PROCEDURE PROC AS
CURSOR C1 AS SELECT * FROM EMP;
BEGIN
FOR R IN C1
LOOP
[code].....
My question is while creating procedure i want to check if the object exist in database or not.
If EXIST
NO PROBLEM MY CODE CREATE THE PROC AND EXECUTED FINE
IF NOT EXIST
I don't want an exception to be thrown stating "OBJECT DOES NOT EXIST" I wanted PL/SQL engine not to execute the particular select statement itself and continue executing other select statements.
The reason why have such kind of wierd requirement is my program displays all the CEMLI objects in any 11.5.10 instance. I don't know whether they have installed discoverer or not. if they installed it no problem else my program have to eliminate.EXECUTE IMMEDIATE, REF CURSOR becoz i tried it and works fine.but not able to wrap in WRAPPER UTILITY 8.0 versions.
Call A Procedure From Another Package?
Dec 10, 2007in a certain procedure I'm trying to call a procedure from another package in the same Schema. Package-name: Haku_Hops, procedure-name: veto and submitted is a parameter called opnum. So the following brings no problem:
Hops_Haku.veto(opnum);
But what if in the beginning of the package body I create the following variable: hak_pah := 'Hops_Haku.'; Is it then in anyway possible to call this other procedure through this variable, like e.g. hak_pah||veto(opnum);?
Until now I've only gotten error, even after declaring the variable in the declaration part.
SQL & PL/SQL :: Running Procedure Within A Package?
May 24, 2011I have a package which has two procedures in it.
The second of which was put in just as a test:
PROCEDURE DST_RPT_INVOICE_REPRINT(refCur OUT Dsti_Rpt_Init_Pkg.RC, param_locationid VARCHAR2,
param_companycode VARCHAR2, param_frominvdate DATE, param_toinvdate DATE, param_project VARCHAR2,
param_invtype VARCHAR2, param_printed NUMBER) AS.....
Dsti_Rpt_Init_Pkg.PRINT_OUTPUT(strSql);
END DST_RPT_INVOICE_REPRINT
All this has within is an SQL statement which is built up (using the string, 'strSql') How can I view the output of a refCur to check what the final strSql is?
SQL & PL/SQL :: Call A Procedure In A Different Package?
Sep 13, 2010I am wrinting a procedure. I want to call a procedure in a different package and get its out value to a variable.
how can I do that in PL SQL?
SQL & PL/SQL :: Pass Object (or) Table As Argument To Remote Procedure?
Jul 18, 2012Does it possible to pass object (or) table as an argument to a remote procedure?
View 2 Replies View RelatedSQL & PL/SQL :: How To Pass Type Object As A Parameter To Stored Procedure
May 9, 2012I am fairly new to oracle, here's what I am doing.
Create or replace type csc_info as object( source_code varchar2(10),
Docno varchar2(10),
Key_value_1 varchar2(10),
Key_value_2 varchar2(10));
[Code]....
I need to test the procedure how do I pass the inputs for the type object csc_info?
SQL & PL/SQL :: Call Private Procedure Outside Of The Package?
Mar 2, 2010There is any way to call private procedure out side of the package.
View 5 Replies View RelatedSQL & PL/SQL :: Trigger Impacting A Procedure In The Package
Jun 27, 2012Recently I created a trigger in my production environment which affected a procedures execution.
Trigger code is as below
CREATE OR replace TRIGGER chk_fresh_lead_time
BEFORE INSERT ON location_refnum
REFERENCING NEW AS NEW
FOR EACH ROW
WHEN (NEW.location_refnum_qual_gid = 'FRESH_LEAD_TIME'
[code].......
This trigger will check if a value is inserted on Location ref num table for the qualifier LEAD_TIME only if the value exist in Fresh template table else it will throw an error message as Quote: Add the fresh template and then add the LEAD_TIME value
We have a procedure in one of the package which inserts values on the same Location ref num table but for a different qualifier say PENDING and not LEAD_TIME as above, but still the procedure is not being executed due to this trigger. How this trigger is affecting the procedures execution.
SQL & PL/SQL :: Difference Between Oracle Procedure And Package?
Jan 7, 2013difference between oracle procedure & package.
View 1 Replies View RelatedSQL & PL/SQL :: Scheduling A Stored Procedure / Package?
Mar 9, 2010I need to schedule a stored procedure and a stored package every day @6:30 AM.
I have also a merge statement that I need to execute before stored procedure is executed.
PL/SQL :: How To Test Procedure / Function / Package
Sep 16, 2012How can i test my Procedure /Function/Package, i mean how to unit & integration test my Procedure /Function/Package. Is there any tool available in the market, or we have to test in manually .
View 6 Replies View RelatedPL/SQL :: Get A Called Procedure / Function Name Within Package?
Jan 11, 2013is it possible to obtain a called procedure/function name within package?
For a measuring and tracing purpose, I would like to store an info at the beginning of each procedure/function in package with timestamp + additional details if needed.
For example:
CREATE OR REPLACE PACKAGE BODY "TEST_PACKAGE" IS
PROCEDURE proc_1 IS
BEGIN
[Code]....
I would like to replace "???????" with a function which would return a name of called procedure, so result of trace data after calling TEST_PACKAGE.proc_2 would be:
11.1.2013 09:00:01 START.*TEST_PACKAGE.proc_2*
11.1.2013 09:00:01 START.*TEST_PACKAGE.proc_1*
11.1.2013 09:00:01 END.*TEST_PACKAGE.proc_1*
11.1.2013 09:00:01 END.*TEST_PACKAGE.proc_2*
I tried to use "dbms_utility.format_call_stack" but it did not return the name of procedure/function.
Client Tools :: Execute A Procedure With Parameter Of Object Type?
Mar 29, 2010I am trying to execute the procedure from toad, where the type is like an object.How can I do that?
CREATE OR REPLACE TYPE list_t AS TABLE OF list_objtype;
CREATE OR REPLACE TYPE list_objtype AS OBJECT
( Emp_ID NUMBER(5),
EMp_Name VARCHAR2(32 BYTE)
);
In the following procedure I am calling list_t, but how would i pass the values to it?
PROCEDURE modify_settings
( p_List in list_t,
p_info out varchar2)
DECLARE
p_List TABLE;
[code]...
Export / Import Of Procedure - Function / Package
Jun 9, 2012Can we Export & Import of Procedure, Function & Package selection by name, as we can export & import of one or more table by name
View 2 Replies View RelatedSQL & PL/SQL :: Mail Reading / Saving Through Package Or Procedure
Nov 14, 2011sample code to read attachments in inbox(from POP3 mail server) using plsql package or procedure.
View 6 Replies View RelatedSQL & PL/SQL :: Capture And Reference Parameter Value Of Procedure In Another Package
Jun 8, 2011I need to know how to capture the Parameter Value of a Procedure in a Variable and reference that variable in another Procedure or Package.
View 12 Replies View RelatedPL/SQL :: Counting The Number Of Lines For Each Procedure In A Package
Jul 31, 2012I would like to write a query on USER_SOURCE that can display the number of code lines for each procedure/function in a package. Is it possible to write such a query? Maybe by using analytical functions?
for example in the following example i would like to count the lines between
"PROCEDURE proc1 IS" and "END proc1;" and between "PROCEDURE proc2 IS" and "END proc2;"
SQL> select text from user_source where name='PKG_TEST' and type='PACKAGE BODY';
TEXT
--------------------------------------------------
PACKAGE BODY PKG_TEST IS
/*************************************************
****/
PROCEDURE proc1 IS
BEGIN
update t1 set EDITION_NAME = 'AAAAAAA';
commit;
END proc1;
[code]....
How To Extract DDL Of Table / Package / Procedure Using SQL Code
Jan 5, 2007how to extract the ddl of a table/package/procedure using SQL Code?
I found a method, but it's only supported from Oracle9i and obove, im using Oracle8i
PL/SQL :: Call VB Function From A Package Stored Procedure
Apr 30, 2013I need to call the VB function below from a Procedure's PL/SQL code and capture the returned variable into a varchar2 variable.I looked at the several means and nothing seems to work.
View 5 Replies View RelatedHow To Audit Execute On Specified Procedure Or Function In Package
Oct 4, 2012My purpose is to audit the execution of a specified procedure, function in a package. So I try this audit option audit execute on dbms_java.longname Althought I'm using SYS, it leads to this error:
SQL Error: ORA-00942: table or view does not exist 00942. 00000 - "table or view does not exist" But when I try audit execute on dbms_java It's ok and it audit every statement that using that package dbms_java. But thing I want is audit the specified procedure on this package, not all of this package.
why DBA_OBJ_AUDIT_OPTS show DBMS_JAVA package object type is procedure ???