PL/SQL :: Calling Dbms_Scheduler From Forms Trigger To Invoke SqlPlus Script In Linux

Mar 25, 2013

I would like to use Dbms_Schedule to call SqlPlus script in Linux .

BEGIN     
sys.Dbms_Scheduler.Create_Job (
job_name => 'TEST_SQL_JOB',

[Code]....

This is giving me the error: ORA-27369: job of type EXECUTABLE failed with exit code: No such file or directory

BUT when I issue the command: /usr/local/bin/sqlplus -s s/ibs @/usr2/dms/run/lkp_sql_test.sql
it works fine.

View 4 Replies


ADVERTISEMENT

SQL & PL/SQL :: DBMS_SCHEDULER Calling Shell Script

Sep 13, 2011

I am facing issues with DBMS_SCHEDULER..I am receiving error while executing the "DBMS_SCHEDULER.run_job"..The OS folder has full permission.

OS : UNix
Database: 10g
====================================================================
Error Received:

ERROR at line 1:
ORA-27369: job of type EXECUTABLE failed with exit 274664
ORA-06512: at "SYS.DBMS_ISCHED", line 150
ORA-06512: at "SYS.DBMS_SCHEDULER", line 441
ORA-06512: at line 1
THE CODE IS LISTED BELOW:
[code]....

View 24 Replies View Related

Forms :: Calling Validation In Pre-insert Trigger

Nov 10, 2010

my purpose is when PRE-INSERT trigger fires validation should be done like date format , primary key in table if validation is ok then a value of text box should be set to sequence no . else it should generate message

View 9 Replies View Related

Executing A Job Using DBMS_SCHEDULER Inside A Trigger

Oct 10, 2013

I would like to execute an external batch file in Windows using DBMS_SCHEDULER in an Oracle database (10g or a higher version). I intend this to be done through a trigger, which would be called on encountering specific errors in Oracle.

The problem is that I can't create triggers on SYS objects, but DBMS_SCHEDULER is owned by  (and as far as I understand, supposed to be used with) SYS user. what permissions need to be granted to which user? Also, can this be done on creating a new user and not using the default SYS and SYSTEM users? 

View 11 Replies View Related

Forms :: How To Invoke Dll From Oracle 10g

Feb 9, 2010

I want to know how we can invoke a .NET dll from Oracle forms? I did some research and found that WebUtil or ORA_FFI package can work in this process.

Being new to this concept, I am looking for documentation specific to my concern.

View 4 Replies View Related

Sqlplus Is Not Working After Oracle 10g Client Installation On Linux Server

Oct 11, 2012

just now i installed oracle 10.2.0.1 client version in one my linux server. after successfully installation sqlplus is not working .

below are my .profile details.

# Set up the shell variables:
EDITOR=vi
export EDITOR
### Set the umask
umask 022
### Set ulimit

[code].....

View 4 Replies View Related

Forms :: How To Invoke And Display Scanned Image

May 26, 2010

How to invoke and display a scanned image side by side with an Oracle Form without minimizing one of the two. I used the code below to call my document, but when i navigate to it so as to be able to see the detail , the oracle form will be dismissed and vice-versa.

DECLARE
v_claim varchar2(400):=:global.photo_path||:b4.doc_no||'.JPG';
BEGIN
client_Host('cmd /c START "" "'||v_claim||'"');
[code]....

Should there be another better way,

View 10 Replies View Related

Forms :: Using Java Importer Tool To Invoke Web Services From Oracle?

Feb 1, 2011

I am trying to use the Java Importer tool to invoke web services from Oracle forms.

During my research on Java Importer tool, I found that Quote:"The class browser lists all of the Java classes found on the CLASSPATH. The classes are ordered in the same way that they are represented in the CLASSPATH."

The above quote is from Oracle Documentation.

I want to know where I can find the CLASSPATH so that I can add new Java Classes to it. Our forms builder runs on Unix environment.

View 5 Replies View Related

Calling Procedure Using Trigger

Aug 26, 2013

I am in the process of creating a trigger for a procedure I created. The procedure is working fine but I keep getting an error on the trigger. I am getting Error(7,5): PL/SQL: Statement ignored AND Error PLS-00306: worng number of types of arguments in call to 'INSERTINTOPHYSLOG'

Here is my procedure:

create or replace PROCEDURE INSERTINTOPHYSLOG
AS
prec_num long;
srec_num long;

[Code]....

View 2 Replies View Related

Calling Procedure With Commit From Trigger

Dec 8, 2006

I searched, found this one hit and according to mateoc15, you cannot commit within a procedure that is called from a trigger. He must be right, because mine is not committing either, nor are any errors given.

Trigger

Create or replace trigger owner_name.table1_trg2
after update on table1
for each row
call owner_name.procedure1;

procedure Code (psuedo):

Create or replace procedure1 as
begin
update table1 set col1 = 'whatever';
commit;
exception when others then
rollback;

Executing the procedure as owner_name on SQLPlus works fine, but when I update a column of the table via the PL/SQL package (on the web form), the column does not update, telling me that the procedure never fired from the trigger.

View 5 Replies View Related

SQL & PL/SQL :: Trigger Calling An Autonomous Stored Procedure

Jul 7, 2011

I have a trigger which is calling a stored procedure that has PRAGMA AUTONOMOUS_TRANSACTION defined. The values that are passed from the trigger have been committed already but it appears that the values are not available in the stored procedure. I'm not positive of this since the ability to log/commit is difficult and the timing of the output is confusing me a bit. I'd like to know if it's expected that any passed values are simply available in the stored procedure regardless of the AUTONOMOUS_TRANSACTION?

View 18 Replies View Related

Unable To Change Password In SQLPLUS After Trigger Added

Aug 17, 2012

One of my Customer had followed the document applied pertaining to mitigate against vulnerability CVE-2012-3132.

New Document Mitigation steps for CVE-2012-3132 [ID 1482694.1]

This was applied to a database and it stopped the 'password' command from succeeding in SQLPLUS. Once the trigger was disabled, it worked fine.

ORA-00604: error occurred at recursive SQL level 1
ORA-06531: Reference to uninitialized collection
ORA-06512: at "SYS.NAME_SECURITY", line 165
ORA-06512: at line 2

Why is this behavior seen? By the way, he was able to change the password using TOAD. Only sqlplus is the issue.

View 2 Replies View Related

RAC/ASM Clusterware Installation :: Dataguard Trigger For Linux Services?

Oct 3, 2012

we are running oracle database 11.2.0.3 and tomcat on the same machine(SLES 11).

I need to contol tomcat(start/stop) depending to database status. For example, if database stops or become standby then to stop tomcat service.

View 2 Replies View Related

ODI Invoke Is Not Generating XML Properly

Feb 5, 2013

In weblogic server Axis2 is deployed and it is showing Active.And we have uploaded ODI invoke service also in AXIS2 succesfully and it is showing Active status also...By using the soap its generating the XML with below mentioned error..

some info:- We rae using ODI 10g.
Weblogic 10.3.5.0

XML GENERATING:--_

<xs:element name="inPhasesUptoAndIncludingPostDispatch" nillable="true" type="xs:anyType" />
<xs:element name="key" nillable="true" type="xs:anyType" />
<xs:element name="localPolicyAssertions" nillable="true" type="xs:anyType" />

[code]...

The XML page cannot be displayed Cannot view XML input using XSL style sheet. correct the error and then click the Refresh button, or try again later.

The operation completed successfully. Error processing resource [URL]

</xs:schema></wsdl:types><wsdl:message name="invokeScenarioMessage"><wsdl:part name="part1" element="ns...

View 2 Replies View Related

SQL & PL/SQL :: Invoke Procedure With DML And COMMIT Through DBLINK?

May 29, 2012

A simple procedure is created as follows:

Create procedure p1(a varhar2, b varchar2, c_err out varchar2) is
begin
insert into t1 values(a,b);
commit;
exception
when others then
c_err:= substr(sqlerrm,1,250);
end;

It is executed fine.But if it is executed from a dblink as

declare
c varchar2(200);
begin
t1@remote_link('testa','testb',c);
dbms_output.put_line(c);
end;

It is giving error "ORA-02064: distributed operation not supported". How can I pass DML through this procedure and commit from a dblink?

View 5 Replies View Related

Forms :: Call One Trigger Of Item In Trigger Of Form?

Jul 1, 2011

How can "call one trigger of item in trigger of form"

View 5 Replies View Related

Forms :: Calling Applet From Oracle?

Nov 16, 2011

In a form in Order Management, I need to use some information on the page and send it to an applet, currently a JFrame. That applet will then call out to do some credit card work and then return an approval code. At that point I have to update a field on the form with that approval code.

Okay, that is it in a nutshell. Basically, how can I call out to an applet from within an Oracle form? If I can get all the information to the applet I can easily update the database.

View 2 Replies View Related

Forms :: Calling Two Different LOVs At Same Textbox?

Jan 10, 2011

Is it possible to populate two different LOVs on same textbox?

Textbox : ITEM_DESC

LOV1:
select desc, code from items order by 1;

LOV2:
select code, desc from items order by 1;

View 7 Replies View Related

Forms :: Report Calling From Parameter 6i

Feb 7, 2012

I am getting a problem I use lexical Parameter but When I call that through Form my parameter forms didn't call that on report parameter. My query is below as well I have attached all Jpg files to understand. I Didn't getting where I am mistaken.

DECLARE
pl_id PARAMLIST;
BEGIN
pl_id := GET_PARAMETER_LIST('TMP');
IF NOT Id_Null(pl_id)
THEN
DESTROY_PARAMETER_LIST(pl_id);
[code]........

View 3 Replies View Related

Forms :: Database 10g - Calling Sequence

Jan 26, 2013

CREATE SEQUENCE hyd1_seq
START WITH 2100000
INCREMENT BY 1
NOCACHE
NOCYCLE;

this is how i created a sequence in database 10g.

if :SHIP_MSTR.PLACE_FROM = 'hyd1' then
SELECT hyd1_seq.NEXTVAL
INTO :SHIP_MSTR.BILL_ID
FROM dual;

this is how iam calling sequence in form.my problem is once the sequence is generated in form and even if i am not saving a form its generating next value next time.what i want to do is if i am not saving the form that sequence number should again come in bill_id.

View 3 Replies View Related

Forms :: Calling Reports From Oracle 10g

Mar 18, 2012

We are facing a problem when calling the reports from oracle forms 10g. following error message appears during report generation

Rep-52266: The In-Process reports server IT_BHARAT failed to start.oracle.reports.RWException:IDL:Oracle/reports/RWException:1.0

Why this error message is appearing and how to solve. Please find attached the image file showing the problem details.

View 1 Replies View Related

Forms :: IP Or Terminal Name Of The Calling PC On CITRIX

Apr 21, 2004

I need the IP address and/or Terminal name of the calling PC on CITRIX server. My application(forms) is installed on CITRIX and after calling of any form I want to check IP/Terminal in WHEN-NEW-FORM-INSTANCE trigger.

View 3 Replies View Related

Forms :: Installation In Linux OS?

Sep 29, 2010

I am new to linux OS i don't know how to install forms in linux.

the step step process of installation of forms 10g in linux OS.

View 1 Replies View Related

Forms :: Calling Reports 9i - Argument Can't Be Null

Oct 3, 2005

I am calling report9i from forms9i. i am getting following error

invalid report id

when i call a report from form in when button pressed trigger. And also giving the following error

argument(1) can't be null.

v_rep varchar2(100);
v_rep := run_report_object('report5',pl_id);

or

rep_object report_object;
v_rep varchar2(100);

rep_object := find_report('report5');
v_rep := run_report_object(rep_object,pl_id);

where pl_id is the parameter list.

View 34 Replies View Related

Forms :: ORA-00933 When Calling Report From A Form

Nov 8, 2011

I have added a text field on forms 6i which calls reportAfter adding the new field called "appeal_name" it gave me the desired result for two three times and somehow after that it started to throw this error

ORA- 00933. I did try to find solution on the web and was given the hint that this occurs due to space or indentation in the coding. I have used Ltrim and Rtrim to remove any space when I added the text field "appeal_name", Following code has been added

if
upper(ltrim(rtrim(:appeal_name)))!='ALL' then
where_cond:=ltrim(rtrim(where_cond))||' and upper (tbl_donation.appeal_code)='''||:blk_hsbt.appeal_code||'''';
elsif :appeal_name is null then
where_cond:=ltrim(rtrim(where_cond))||' and tbl_donation.appeal_code is null';
end if;

View 1 Replies View Related

Forms :: Calling Report In Object Navigator

Feb 22, 2010

Created a report object "REPORT62" in Forms Objectnavigator

Trigger on When Button Pressed

DECLARE
rep_id REPORT_OBJECT;
rep_result VARCHAR2(200);
BEGIN
rep_id := find_report_object('REPORT62');
rep_result := RUN_REPORT_OBJECT(rep_id);
END;

Report is called in the property

Filename C:DevSuiteHome_1forms est.rdf

When button is pressed error is raised

There was a failure in the Form server during startup. This could happen due to invalid configuration.

View 5 Replies View Related

Forms :: Calling Multiple Reports Through Alert

Feb 15, 2011

I need code for calling two reports using alerts.

View 4 Replies View Related

Forms :: Calling Java Utility From Oracle 10g?

Jul 11, 2013

My colleague created java utility to upload file to ftp server and sent me the URL to call the utility.

Now I want to create a push button in my oracle form to call that utility.

how can I do that in forms 10g.

View 1 Replies View Related

Forms :: Calling Internet Explorer Within Form

Oct 4, 2011

is there any way to call internet explorer with in form.i want to provide net fascility to the users using 10g forms.

I have tried some beans but some restrictions are there.it is not properly displaying page.

View 3 Replies View Related

Forms :: Calling A Website In A Form Using Hyperlink

Apr 29, 2013

I have a form with two text items and one text label fields. The value of the label field is "click here for more help". now i want to show the URL.... if i click the text lable. I also Tried when mouse click trigger...but it shows the website when i click the text items .... it is not working in the label. URL....

View 2 Replies View Related







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