Forms :: How To Call Procedure From One To Another Object Library

Jan 29, 2013

I have one procedure "PROC_A" in LibraryA, Is it possible to call this procedure PROC_A from LibraryB.

View 1 Replies


ADVERTISEMENT

Forms :: Calling Procedure At (Form / Library And Database) Level

Mar 17, 2011

I've a procedure let us say SALES_PROC on Form Level and same procedure in Library and in Database also.

-How to call SALES_PROC created at Form Level?
-How to call SALES_PROC created at Library Level (.PLL)?
-How to call SALES_PROC created as stored procedure in Database?

View 5 Replies View Related

Call Interface :: What Oracle 9.2 Installation Use To Have OCI Library Header Files

Sep 6, 2012

There are only OCI headers in 9.2.0/rdbms/demo directory in our installation of Oracle 9.2:

9.2.0/rdbms/demo/ocixad.h
9.2.0/rdbms/demo/oci.h
9.2.0/rdbms/demo/oci1.h
...

In Oracle 10.2 installation there are OCI headers in rdbms/public directory:
10.2.0/rdbms/public/ocidem.h
10.2.0/rdbms/public/ocidfn.h
10.2.0/rdbms/public/ocikpr.h
10.2.0/rdbms/public/oci.h
10.2.0/rdbms/public/oci1.h
...

What should be installed additionally to have OCI headers in rdbms/public in Oracle 9.2.0?

View 0 Replies View Related

Forms :: Call Associative Array In Oracle Procedure?

Apr 25, 2013

I've one package in which one record is created. associative array is craeted on that record.create procedure on associative array.using forms 6i i want to call this procedue.(package_name.procedure_name(paramerters)). but my problem is what paramerter shuld i provide to excute the procedure?like PK_EXCEL_TO_DB.PR_DO_INSERT(LIST_ROUTE); but i am getting error while doing this.

CREATE OR REPLACE PACKAGE PK_EXCEL_TO_DB IS
TYPE ROUTE IS RECORD (COL_ROUTE VARCHAR2(255), VAL_ROUTE VARCHAR2(4000));
TYPE LIST_ROUTE IS TABLE OF ROUTE;
PROCEDURE PR_DO_INSERT(i_lData IN LIST_ROUTE);

[code]...

View 14 Replies View Related

Forms :: Call Oracle Form Using Stored Procedure?

Mar 14, 2011

How to call Oracle Form using a Stored Procedure?

Under

create or replace procedure ........

Begin
.......

End

Inside such procedures , is it possible to call a form ?

View 4 Replies View Related

Forms :: Path To Use DLL - Library Not Available

Oct 18, 2013

How to use the DLL? My DLL is loaded on the client host in the C: Documents and Settings USER webutil. When you try turning to the library, I get an error:

WUL-928 [CApiFunctions.set_invokeoncespec ()] EXAMPLE.DLL library is not available or does not contain a function MYFUNCTION

View 11 Replies View Related

PL/SQL :: How To Call A Function Having OBJECT Type As Return Type

Mar 26, 2013

I've the following function returning OBJECT type. how to call this function

CREATE OR REPLACE TYPE GET_EMP_OBJ is object
   ( emp_name varchar2(50) ,
     mgr_id   number,
     dept_id  number
   );

[Code]...

The above function got created successfully. And i'm confused how to call this functions. I tried like below but didn't work

DECLARE
  t_emp_info_1  GET_EMP_OBJ ;
BEGIN
   t_emp_info_1 := get_emp(7566) ;
   for i in 1..t_emp_info_1.COUNT
      LOOP
         DBMS_OUTPUT.put_line ('Values are'||i.emp_name ) ;
     END LOOP;
END;  

View 7 Replies View Related

Forms :: FRM-10102 / Cannot Attach PL/SQL Library

Mar 19, 2007

FRM-10102: Cannot attach PL/SQL library XXX. This library attachment will be lost if the module is saved.I am getting above error message while opening Oracle 6i Form in 10g.

I get the following Alert message when I try to attach the library to my form - Attached library name S:.........xxx.pll contains non-portable directory specification. Remove path? Yes/No?

If I select 'No', the Form compiles and runs without any error.But if I select 'Yes', I get the following error message: FRM-40039: Cannot attach library xxx while opening form.

All files (fmb, fmx, pll, plx) are on the same path. I detached and then re-attached the library but this didn't work for me?

View 13 Replies View Related

Forms :: Can't Open Library - D2KWUT32.DLL

Jan 26, 2010

I working in windows environment and using form 6i. Everyone have used the same form and they are getting properly. But when i run the same form i am getting the following error.

PDE-DFF003: Can't Open Library : D2KWUT32.DLL

I am getting the above error when i execute the following line on when - button - pressed

w_user := Win_Api_Environment.Get_Windows_username(False)

View 1 Replies View Related

Forms :: PDE-PLI018 Could Not Find Library (form Name)

Jan 25, 2010

I am using forms 6i with 10g data base. i have compiled a form in developer 6i after that when i open *.fmb file it is showing PDE-PLI018 Could Not find Library "form name". i have not attached any library in form.

View 4 Replies View Related

Call A Procedure From Another Package?

Dec 10, 2007

in 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.

View 6 Replies View Related

SQL & PL/SQL :: How To Call A Procedure In Cursor

Sep 11, 2012

I have a procedure(used to delete the data from all tables) which taking two parameters as input. like EXCS_kiwldate(1,'keepitems')[/color][/size] but it taking only one parameter at a time if i want to delete all data using that procedure by calling it in a cursor

how to write a cursor by giving loop function to delete the data once.

View 3 Replies View Related

SQL & PL/SQL :: How To Call Outside Function In Procedure

Dec 3, 2011

How to call outside function in procedure

View 11 Replies View Related

SQL & PL/SQL :: Call A Procedure In A Different Package?

Sep 13, 2010

I 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?

View 10 Replies View Related

PL/SQL :: How To Call Procedure In Jasper

Sep 16, 2012

How to call plsql in jasper. i have try this code in jasper -> select query langiuage = plsql

{CALL STD03_MERIT_PROCESSING($P{std03_studentVal},$P{std03_studentVal})}

but there is error taht said no data found.

View 1 Replies View Related

PL/SQL :: How To Call Procedure From Sql Prompt

Jun 12, 2012

I have a procedure with signature as proc_temp(deptno in number, empdetails out sys_refcursor);

how can i call this procedure from sql prompt.

View 2 Replies View Related

PL/SQL :: Syntax To Call Procedure?

Apr 8, 2013

I have 2 procedure defined in a package.Procedure is defined so that, it has 3 varchar2, which is used to store the insert statement.

ex:
CREATE OR REPLACE PACKAGE PK_LOGIC AS
PROCEDURE MOVE_table1_TO_table2;
PROCEDURE MOVE_table2_TO_table3;
END PK_LOGIC ;
/
[code]....

My problem is how can we execute this procedure in SQL DEVELOPER tooL?I tried using,

CALL PK_LOGIC .MOVE_table1_TO_table2(); or EXEC PK_LOGIC .MOVE_table1_TO_table2;

View 9 Replies View Related

SQL & PL/SQL :: Check If Object Exist Or Not While Creating Procedure?

Mar 5, 2012

I 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.

View 14 Replies View Related

Trace Particular Object (procedure / Package) On Database?

Dec 13, 2012

How do I trace an particular object (procedure/package) on the database. my database version is Oracle 11g(11.2.0.2)

View 2 Replies View Related

Forms :: How To Create Library Functions To Show Alert

May 24, 2010

Am using Oracle 10g Forms and Databse.

My form Consists data block blk_user with two items username and password

Both user name and Password are required Fields.

When user left these items Empty To show Alert

I Created Below Procedure and Called in Form_Level ON-ERROR Trigger.

PROCEDURE pcd_io_alert IS
itm_name VARCHAR2(20);
BEGIN

[Code].....

how to call or create this procedure as Library functions and call the created library in form To Show Alert. Actually I want to create library functions to Validate and Show Alert Mesages.

View 1 Replies View Related

Forms :: Adding 5 Mins To A Form Field In Library

Jun 24, 2013

I have a date field in my form (date.start_time) in which I want to reference in a library and add 5 mins to the time (since its in the lib I am coding this I need to use name_in ). My current code is:

copy(name_in('date.start_datetime')+5/24/60 , 'DATE.END_DATETIME')

However, this seems to be erroring.

View 2 Replies View Related

Forms :: Using PIPELINED Return Inside Custom Library

Jun 5, 2013

I would like to know if it's possible to use PIPELINED return inside a custom library with Oracle Forms Builder? For now, i try to use it, but i get error about client side.

my code.

PACKAGE TEST IS
TYPE measure_record IS RECORD(
l4_id VARCHAR2(50),
l6_id VARCHAR2(50),
[code].......

the body compile, but not the other part. I would like after call the select * from test.get_ups(0); with a cursor into another function.

View 3 Replies View Related

Forms :: FRM-40039 Cannot Attach Library While Opening A Form

Apr 1, 2010

My client is Oracle 10G DS Forms Developer. The application server is on a Solaris 64 bit sparc system. I have copied all the forms and libraries to my forms directory under C:DevSuiteHome_1forms10g_rel1 from the application server. and placed the following directory in my FORMS_PATH in the registry entry.

Now I am opening up the forms in my Forms builder and running the form. I get this error. I have the attached library in the form but I still get this error:

FRM-40039 Cannot attach a library while opening a form

View 1 Replies View Related

SQL & PL/SQL :: How To Call A Procedure From Anonymous Blocks

Jul 12, 2010

I have a written a script which doesnt take any parameter. this is an anonymous block. I run my script as below: SQL> @filename.sql

I would like to convert this into a procedure which should be called in an anonymous block. run a procedure from an anonymous block.

I would also like to know how to run the same from the SQL prompt.

View 5 Replies View Related

SQL & PL/SQL :: Call Private Procedure Outside Of The Package?

Mar 2, 2010

There is any way to call private procedure out side of the package.

View 5 Replies View Related

SQL & PL/SQL :: Procedure Call Inside Trigger?

Aug 8, 2011

I am trying to call procedure inside trigger.. but i get error ora-04098 ..

create table emp_hstry
as
select * from emp
where
1= 2 ;

create or replace procedure emp_del_hstry(v_empno NUMBER ,
v_ename VARCHAR2,
v_job VARCHAR2)
is
insert into emp_hstry (empno,ename,job)
values (v_empno,v_ename,v_job);
COMMIT;
end;

create or replace trigger emp_del_hstry1
after insert or delete
on emp
for each row
begin
if deleting then
emp_del_hstry(:old.empno,:old.ename,:old.job);
end if;
end;

delete from emp
where
empno = '7369'

AFTER delete statement run i get ora-04098 message i also check show error command ,but still i am not getting solution of this error ..

View 7 Replies View Related

SQL & PL/SQL :: How To Call Procedure Dynamically Using Execute Immediate

Jan 2, 2011

I have a procedure p1 in schema s1.i want to call this procedure in schema s2 dynamically.how can i do?

View 4 Replies View Related

PL/SQL :: Call Java From Stored Procedure

Aug 21, 2012

We have a stored procedure named proc_java_test . From this stored proc, we need to call a java class named java_test.java

This class posts messages to a queue hosted on an app server running on a separate box.

create or replace
PROCEDURE PROC_JAVA_TEST
(
num IN NUMBER
)
AS LANGUAGE JAVA
NAME 'java_test.post(int) ';

Is it mandatory to place java files in oracle_home/bin ? I tried placing the file on some other location and then calling it from stored proc. It did not work. Can we point oracle to read java file from location other than oracle_home/bin?

Oracle version used: 11.2.0.2r3

View 4 Replies View Related

SQL & PL/SQL :: Pass Object (or) Table As Argument To Remote Procedure?

Jul 18, 2012

Does it possible to pass object (or) table as an argument to a remote procedure?

View 2 Replies View Related

SQL & PL/SQL :: How To Pass Type Object As A Parameter To Stored Procedure

May 9, 2012

I 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?

View 2 Replies View Related







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