Getting error while using UTL files

Advertisement
October 11

hi All,
I'm getting following error -
ORA-29282: invalid file ID ORA-06512: at "SYS.UTL_FILE", line 774 ORA-06512: at "IMPORT_NEW", line 781 ORA-01722: invalid number
To used UTL i have done following steps -
1. created directory
2. grant read, write to that directory from sys
but every time I'm getting above error.
Can any one tell me, where am I going wrong?
Subir

Advertisement

Replay

here is the basic code...
CREATE OR REPLACE PROCEDURE import_new
begin
logfilename :=
'DnB_Source_'
|| datasetversionid
|| '-'
|| TO_CHAR (SYSDATE, 'YYMMDDHH24MI')
|| '.log';
vsfile := UTL_FILE.fopen ('import_LOG', logfilename, 'w');
UTL_FILE.put_line
(vsfile,
'No treatments have been done, Data are already in Source area.'
UTL_FILE.put_line (vsfile, '');
UTL_FILE.put_line (vsfile,
'Run began on '
|| TO_CHAR (beginrun, 'DAY MON DD HH24:MI:SS')
UTL_FILE.put_line (vsfile,
'Run ended on '
|| TO_CHAR (endrun, 'DAY MON DD HH24:MI:SS')
UTL_FILE.fclose (vsfile);
exection
END import_dnb_new

View 6 Replies

File download is getting error while using popup

October 11

Hi experts, Working in jdev 11.1.1.3.0, ADF BC with rich faces. I am downloading word document from ADF application, i am using fileDownloadActionListener it's working fine, but before opening any file if i invoke any popup, like in my case i have to

View All Replies

Error While using LKM File to Oracle(SQLLDR)

October 11

Hi , When I am trying to load the data from flat file to oracle table using LKM File to oracle (SQLLDR) it is getting failed with below error message. SQL*Loader-128: unable to begin a session ORA-01034: ORACLE not available ORA-27101: shared memory

View All Replies

Getting error while running jar file

October 11

Hi, I am getting below error while running the jar file "Exception in thread "main" java.lang.NoClassDefFoundError: oracle/jdeveloper/layout/XYLayout:" I have created a simple ADF desktop app in which i am displaying the frame.I create

View All Replies

Getting error while Using BAPI Interface in VB

November 30

Hi, I m getting error message while creating object of SAP.BAPI.1 Error message is "out of memory : run time error 7". do I need to install any patch to my local PC? If yes then from where could i get that patch. Plz help me out. Thanks & Re

View All Replies

Getting error while loading flat file into table.

October 11

I am using ODI 11 and i am trying to load data in oracle database table using source as flat .txt file . When i execute the interface , i am getting below errors. ODI-1217: Session INF_FILE2TAB (31022) fails with return code 7000. ODI-1226: Step INF_

View All Replies

Getting error while using CAN api's. Says channel not found in MAX.

November 30

Hi, I am using NI-CAN series2, can card. The same is not connected to my system. Hence i have used the virtual channel 256. Here i am reading the DBC file and providing an option to the user to select a set of messages to transmitt\receive. But i am

View All Replies

Getting Error while using UTL_MAIL procedure

October 11

Hi All, I have written a simple PL/SQL block in which I call the UTL_MAIL.SEND procedure: DECLARE vSender varchar2(100); vReceiver varchar2(100); vSubj varchar2(100); vMesg varchar2(100); vMType varchar2(100); BEGIN vSender := '[email protected]'; vR

View All Replies

Getting error while using IF - ELSE condition in an LOV....

October 11

Hi All, I have a Table by name TEST having columns - PROJECT,PERSON,MANAGER as shown below. PROJECT     PERSON     MANAGER PR_A      ABC     YES PR_B     DEF      PR_C     XYZ     YES (Please read the above table as - PR_A as a PROJECT ; ABC as PERSO

View All Replies

In Oracle 10g Error while using COLLECT

October 11

I getting error while using collect in 10g SQL> ed Wrote file afiedt.buf 1 SELECT deptno 2 , COLLECT(ename) AS emps 3 FROM emp 4 GROUP BY 5* deptno SQL> / , COLLECT(ename) AS emps ERROR at line 2: ORA-00932: inconsistent datatypes: expected NUMBER g

View All Replies

Getting error while compiling frmcmp_batch batch file

November 30

HI I am getting error while running frmcmp_batch commant to create .fmx file following is command that i am using $ frmcmp_batch module=$AU_TOP/forms/US/DEMxxEOR.fmb userid=APPS/apps output_file=$PO/forms/US/DEMxxEOR.fmx module_type=form batch=no com

View All Replies

I am getting error while connecting to sqlplus by using apps account in 11i

October 11

i am getting error while connecting to sqlplus by using apps account in 11i. Does anyone has similar error. [[email protected] admin]$ sqlplus SQL*Plus: Release 8.0.6.0.0 - Production on Mon Sep 13 14:34:52 2010 (c) Copyright 1999 Oracle Corporation

View All Replies

I paid for adobe reader to convert pfs to excel. It used to work but now it does not. I get "error while siging in message" but I am signed in. Please fix this or advise.

November 30

Adobe no longer converts pdfs to Excel or Word. I continually get error while signing in message. But I am signed in. I paid for service and expect it to work. I can get no help form adobe. Please help now.Hi adoberror, I'm sorry that you're having t

View All Replies

Error while using DB Adapter in BPEL[Calling a procedure or function]

October 11

Hi I am getting Error while executing the BPEL Process. 1) I created a BPEL Process which uses a DB Adapter. I am using call a procedure or function. My Procedure is shown below. It takes a string a s input parameter and executes that string. I have

View All Replies

"Error while using XML iview" with XML iview template

October 11

Our portal platform: HP-UX,  WAS 6.40 JAVA, EP 6.0 SP14 We created an XML iview using XML iview template and configured the XML source URL with RSS feeder addresses such as"https://forums.sdn.sap.com/rss/rssmessages.jsp?forumID=41". And then sel

View All Replies

Product Instance Registration Error Message: "System Failure: Error while retrieving xml file from database"

October 11

Hi Planning installation Gurus, Did u get any luck to resolve this problem as i am also facing same problem "Error creating instance" during install of Planning 9.3.1. i tried 30-50 times reconfiguration every time same problem.. OS: Vista Premi

View All Replies

Error while using XML Iview, please contact your system administrator.

October 11

Hello everybody, I have already posted a detailed message for the XML iview problem sometime back but havent got any reply so far. All the replies had come from users who are also facing the same problem. I am trying to use a XML iview for fetching R

View All Replies

Getting Error while starting JDeveloper - "An unexpected severe error"

November 30

Getting Error while starting JDeveloper - "An unexpected severe error has occurred in JDeveloper". Its asking for exit after saving files. Below is the stack trace. I am using Jdeveloper 11.1.1.3, The latest version. and i installed most of the

View All Replies

Error while importing .xml files in informatica

November 30

Dear Rajendra, Please use this. <?xml version="1.0" encoding="UTF-8" standalone="no"?> <my:MainFields xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://schemas.microsoft.

View All Replies

Getting error while taking MAX DB trans log backup.

October 11

Hi, I am getting error while taking trans log backup of Maxdb database for archived log through data protector as below, [Critical] From: [email protected] "MAX" Time: 08/19/10 02:10:41 Unable to back up archive logs: no autolog medium fo

View All Replies

Tags:

  1. Nokia 503 marathi lengveg read softwear
  2. apple tv hulu no signal
  3. mac internet recovery mac mini2009
  4. imovie program for a1151
  5. nokia 6120c (B20.04) way
  6. hp g60 diskpart uefi
  7. lsmw RV14BTCI
  8. 305500 non oracle exception
  9. 8QYE
  10. DCD5
Copyrights 2019 Fcffair BigData Resource, All rights reserved