Forms :: FRM-92100 Error In Oracle 10.1.0.4 Under UNIX B.11.11
Jul 30, 2010
We have recently migrated from IAS 9.0 to IAS 10.1.2 in one of our development Server hosted in UNIX B.11.11. We are using Oracle forms as front end. We have re-compiled all the existing forms and libraries using IAS 10. There were no changes in the forms and libraries. We deployed the forms in our development box and configured it, since we are using our own environment specific copy of default.env file. With few of forms we are facing the FRM-92100 error mentioning the "Connection to Server was interrupted". Most of the forms are running fine but with few forms we are facing this error. Some of details are:-
Oracle 10.1.0.4
UNIX B.11.11
IAS 10.1.2
NLS_LANG parameter in default.env is set to "american_america.WE8ISO8859P1"..We have even tried copying the libraries in our local system and then opening and saving them and ftp'ng them back in to UNIX server and then recompiling there with full permissions but still unable to resolve this error.
View 2 Replies
ADVERTISEMENT
Jun 23, 2013
I have developed an application Customer Call Handling where the main form of the Application has about 42(Data & Control) Blocks, many canvases and windows.This main form Calls many other forms which all work fine. But whenever this Main form is Cleared,Queried it calls the Code gems_ proc_ clear which has CLEAR_FORM(NO_VALIDATE).Immediately after the Clear_form(no_validate) is fired it throws this error FRM-92100.
On Save too, the form needs to be cleared once data is saved. The save works fine. but when the call to gems_proc_clear is made after save it throws the error again.
Since its the main form of the application, The Call Center users are having difficulty Clearing or Querying the form.
The forms have been developed in Forms 6i Version and work absolutely fine in 6i Test-Server Environment. But the moment we run the Forms in the Live Server(Oracle 11G) Environment when the form is Cleared,Queried this error throws.
View 1 Replies
View Related
Nov 24, 2011
I have a requirement to read a file from windows m/c and write into Unix Server. How can i do that in Oracle forms.
I tried TEXT_IO package.But that is not allowing to access Unix path.
View 2 Replies
View Related
Mar 25, 2010
I installed a printer(HP Laserjet 3390) in UNIX(Solaris).Followed the instructions while installing as to the path it should be present for Reports to read it etc.,Also modified the uiprint.txt file with the desired .hpd file.Logging on to the UNIX machine, I am using the below command
rwrun.sh report=xyz.rdf userid=XXXX/XXX@xxx paramform=no p_orig_org='0825' desformat=pdf destype=printer desname=xxxx batch=yes
This command invokes the printer and
^[%12345X@PJL
@PJL SET RESOLUTION=300
@PJL SET PAGEPROTECT=OFF
@PJL SET ENTER LANGUAGE=PCL
^[%1A^[E^
@PJL RESET
^[%12345X
is what it prints.Realizing that this is because of the missing parameter,tried to change paramform=yes but I am not sure how to pass the parameter.
View 11 Replies
View Related
Jul 1, 2010
my problem is this. I created the java classes using itext to create a document library. Rtf, or. Odt. I integrated classes in Oralce form and everything works. I created a file. Odt application server on a folder and now only remains for me to open the file. The roads are two:
1. Directly from the server, you can?
2. From the client using the API or openoffice launching the executable with cmd?
Oracle Forms is a command to transfer files on the client and run the executable swriter of openoffice?
View 4 Replies
View Related
Feb 22, 2012
create or replace procedure log_file
(
odsm_profile IN VARCHAR2
)
AS
handle utl_file.file_type;
begin
[code].....
i have error when executing this pl/sql procedure in timesten in UNIX
this is the excution error:
Command> exec log_file('hi');
8507: ORA-29280: invalid directory path
8507: ORA-06512: at "SYS.UTL_FILE", line 41
8507: ORA-06512: at "SYS.UTL_FILE", line 478
8507: ORA-06512: at "SIUA.LOG_FILE", line 8
8507: ORA-06512: at line 1
The command failed.
View 6 Replies
View Related
May 19, 2007
I am using Oracle 9i and Unix on my system and trying to execute a UNIX shell command through external procedure in C.I created a shared lib (libextproc.so) for the following function.
int sysrun(char *command)
{
return system(command);
}
This function runs fine when caled through a driver function in C, meaning that the shared lib is fine.In PL/SQL, I have used the following method to invoke a UNIX command:-
create or replace library shell_lib as '/home/ECETRAonsite/oracle/OraHome1/lib/libextproc.so';
/
create or replace function sysrun (syscomm in varchar2)
return binary_integer
as language C
name "sysrun"
library shell_lib
parameters(syscomm string);
/
Now when I call this PL/SQL function to invoke the command, it is run succesfully but does not create the file.
SQL>
1 declare
2 rc number;
3 begin
4 rc := sysrun('/bin/touch /home/ECETRAonsite/oracle/OraHome1/test/sach');
5 dbms_output.put_line('Return Code='||rc);
6* end;
SQL> /
Return Code=0
PL/SQL procedure successfully completed.I have verified that the path for 'touch' is correct.Following are my configuration files.
listener.ora
-------------
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
[code]...
View 1 Replies
View Related
Aug 8, 2012
We would be moving oracle 11g unix sun solaries to oracle 11g Linux readhat OS. what would be the disadvantage and what are the item needs to be verified. Basically advantage of oracle 11g Linux readhat OS.
View 2 Replies
View Related
Mar 23, 2010
Below is my code for calling a report from form in windows environment. I want to use the same report to be called from Unix environment . When m using application server tbanner@.... instead of 'repsrv@ahad-pc' is throwing error its in UNIX environment
REP-51002: Bind to Reports Server tbannerdb.kfupm.edu.sa failed
Declare
v_show_documentVARCHAR2 (2000) := '/reports/rwservlet?';
v_connectVARCHAR2 (200) := 'userid=abdulahad/inshalla@test';
v_report_serverVARCHAR2 (30) := 'repsrv@ahad-pc';
v_report_nameVARCHAR2(100) := 'test3.rdf';
[code].......
View 6 Replies
View Related
Jan 21, 2011
Iam planning to upgrade my Oracle Database from 10G to 11G .
Its on HP Unix Environment 11.23 and
Oracle CRS 10.2.0.4
Oracle ASM 10.2.0.4
Oracle RDBMS 10.2.0.4
Its in RAC env...and Active-Active DB running controlled by tnsnames.ora .
View 8 Replies
View Related
Feb 19, 2011
Am tring to export a data from oracle forms to excel. I use ole2 option. it is working perfectly in my desktop. But when i move the same to our application server, it is not working. I belive OLE is related to Microsoft office and our server is unix based.
View 1 Replies
View Related
Aug 8, 2011
I'm trying to install Oracle 11gR2 RAC on AIX, do we need to turn on Multicasting, can we install without multicasting? Also can I have the ASM disk with external redundancy for OCR and Voting Disk?
View 3 Replies
View Related
Jun 14, 2010
I have a UNIX shell script as following,
#runs the selected process
${ORACLE_HOME}/bin/sqlplus -s ${USER_PASS} >${TMP_FILE} <<EOF
set pause off
set verify off
set pagesize 0
set linesize 2000
set timing off
[code].........
I am passing a Date to the Oracle Procedure in `date +'%b_%d-%H:%M:%S'` format.
rmsqa813.2 /home/ashlaksh> echo `date +'%b_%d-%H:%M:%S'`
Jun_14-02:26:37
The oracle Procedure's SQL is as following,
SELECT ffdh.fiscal_doc_id INVOICE_ID,
ffdh.location_id LOCATION_ID
FROM fm_fiscal_doc_header ffdh,
fm_schedule fs
[code]........
The above SQL is not getting the data as the Date format "AND ffdh.last_update_datetime <=i_last_update_datetime " is not matching..
Do I need to convert the Date ? ( But i_last_update_datetime is DATE)
View 1 Replies
View Related
Oct 17, 2013
I'm on Oracle 11g R1. I've a requirement where user will be putting CSV files on Unix server and I've to create a job which runs periodically to check if any new file is added by user in the folder. If it finds a new file (s), then it needs to identify it and insert its name in an Oracle table. Once file's name is noted, it has to move file from that directory to another one.
View 2 Replies
View Related
Apr 15, 2010
I need to develop a form which has to read and display the contents of a text file that is stored in the Unix system where the Oracle data base is installed. So basically its the database server and not the forms application server.
1. Create an external table for the file everytime when the form is loaded by dropping and re creating the table and base the data block in the form on that table and execute_query and display the contents.
2. I am confused whether to use webutil or utlfile packages to read from the file and display on the screen as the file resides in the database or Oracle server and not forms application server or client machine.
View 5 Replies
View Related
Jun 13, 2013
i need a connectivity code to connect oracle DB in UNIX.pls send me a code exactly.
View 2 Replies
View Related
May 9, 2011
is there a way where i can pass the value from unix to forms?
View 1 Replies
View Related
Jun 6, 2013
I would like to ask you if you know which built-in can I use for transferring a excel file from our Unix box to a table in oracle database, right now we are using webutil_file_transfer.Client_To_DB_with_progress using forms developer, but I need to run as an automatic process uploading form unix into oracle directly without using forms.
View 22 Replies
View Related
Nov 11, 2011
I have a file which is placed on a certain location on unix server. I want to write a code which picks up that file and emails it to certain recipients.
View 3 Replies
View Related
Dec 24, 2012
I want to insert STAT and ENDTIME values for each job in joblist into TBL_DAILY_STATUS table.
E.g. : insert into tbl_daily_status values(STAT,ENDTIME);
#!/bin/ksh
joblist="com_abc_job com_abc_dot_job com_abc_seq com_abc_det"
for i in $joblist
do
STAT=`./JobStatus.pl -i NP1 -z Z8PIMBN -p $i|awk '{print $6}'`
ENDTIME=`./JobStatus.pl -i NP1 -z Z8PIMBN -p $i|awk '{print $4" " $5}'`
echo "$STAT"
echo "$ENDTIME"
done
View 2 Replies
View Related
Mar 8, 2011
I am trying to Push the data from Oracle which is running in HP-UNIX to SQL Server. But don't know the efficient way to connect the SQL server from oracle which is running on HP-UNIX.I have heard about oracle Heterogeneous Connectivity but don't know exactly how to implement it in Unix environment.
View 1 Replies
View Related
Jun 14, 2011
I would like to develop a form which will be replica of windows explorer.It should be able to read all files or files from a specific folder from an unix platform.
if yes can i have a template. I do not want to start from the scratch since I do not have much time.
View 5 Replies
View Related
May 20, 2010
We are using Oracle Applications hosed on UNIX servers. There is a custom form in XXX_TOP/forms/US folder that I need to modify.
My Windows desktop has Forms Builder 10g installed. I ft pied fmb file over from UNIX server to my Windows desktop and tried opening it. I get an error FRM-18108:
Failed to load the following objects: APPSTAND, etc etc.
Obviously I am not doing it right. What is the correct way of modifying a form file sitting on UNIX server, using Forms Builder installed on Windows desktop? Do I need to copy all dependent objects to Windows desktop along with fmb file?
View 2 Replies
View Related
Jun 4, 2010
We have an application that fetches and writes data into oracle database through pro c. oracle datyabase is on another server.
We are storing some secure information into oracle database so we want to encrypt the data sent by our aplication into oracle database.We do not want to use SSL(i.e certificates) and also do not want to make use of Advance Security Option available in oracle and also do not want to make any changes in sqlnet.ora file on server side.
achieve encryption of traffic between our application and Oracle database?
View 13 Replies
View Related
Mar 23, 2013
How to overcome the prompt user id & password to connect oracle DB from Unix environment.
View 2 Replies
View Related
May 4, 2011
I have several forms developed in Oracle forms builder 10g version 9.0.4.0.19. It contains Hierarchical Tree items. when i run this form on this version of oracle, it's running properly. but when i compile and run it on oracle forms 10 version 10.1.2.0.2, it shows an error message stating Assertion Failed!, if I click on the Tree item. I cant find out what and where the problem is. If I build a new form with tree item, it is working properly.
View 1 Replies
View Related
Oct 11, 2012
i am getting ora-12713 error in oracle forms output whle displaying text in textbox.
ORA-12713:character data loss in NCHAR/CHAR conversion
ORA-01403 : no datafound.
these two erros are cuming together in oracle 11g and some data is lossing. other its displaying.
View 3 Replies
View Related
Jul 7, 2010
i tried to run the report via oracle froms 10g in BUTTON CLICK. But i got the error like "FRM-41219 : CANNONT FIND REPORT:INVALID ID". I did the Following code.
DECLARE
repid REPORT_OBJECT;
v_rep VARCHAR2(100);
rep_status varchar2(20);
BEGIN
SET_REPORT_OBJECT_PROPERTY(repid,REPORT_EXECUTION_MODE,BATCH);
SET_REPORT_OBJECT_PROPERTY(repid,REPORT_COMM_MODE,SYNCHRONOUS);
SET_REPORT_OBJECT_PROPERTY(repid,REPORT_DESTYPE,CACHE);
[code]....
View 8 Replies
View Related
Oct 25, 2008
I am using windows Xp environment. Downloaded the software from Oracle website. Database is Oracle Express on windows. Have installed Oracle Forms 10.1.2.0.2 and OC4J also on windows xp Installation is fine and i am able to run forms same day. THe next day i am not able to run Oracle forms, i get error frm-92101 error.
I have tried posting this in various oracle forums and have not got a solution yet. I tried reinstalling. Every time i reinstall, it works for a day (the day i install, i have been able to create forms, compile and run them) but it does not work the next day. THis has happened thrice (reinstalled thrice).
Oracle JInitiator: Version 1.3.1.22
Using JRE version 1.3.1.22-internal Java HotSpot(TM) Client VM
User home directory = C:Documents and SettingsuserProxy Configuration: no proxyJAR cache enabled
Location: C:Documents and SettingsuserOracle Jar Cache
Maximum size: 50 MB
[code]...
View 1 Replies
View Related
Jun 21, 2011
I am getting following error when we submit request through button in forms.but backend it is created.
ORACLE error 6550 in FDPSTP
Cause: FDPSTP failed due to ORA-06550: line 1, column 7:
PLS-00306: wrong number or types of arguments in call to 'XXPL_PO_REQ_INTER_MAIN'
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
View 7 Replies
View Related
