Ошибка oracle 302000

Similar Messages

• A text_io problem: ORA-302000

  Hi,all:
  I have 2 apps on form.
  The first one is to read from file, and the second is to write on the file.
  Firstly, i have created the file on the server, and the file(abc.txt)’s permission is rwxr—r—.
  Then i tested the first one, it can read from file well.
  But when i tested the second, it throwed a exception: ORA-302000.
  I was so confused. why it can read from file with text_io, but can not write?
  Can anyone help me to solve this problem, Thanks so much.
  Here’s my code:
  1.WHEN-BUTTON-PRESSED(to read): works fine
  DECLARE
       in_file text_io.file_type;
       line_bufer varchar2(80);
       lv_strtmp varchar2(100);
       errnum NUMBER                := ERROR_CODE;
       errtxt VARCHAR2(80) := ERROR_TEXT;
       errtyp VARCHAR2(3)      := ERROR_TYPE;
  BEGIN
       in_file := text_io.fopen(‘/home/cn01278/abc.txt’, ‘r’);
       text_io.Get_Line(in_file,line_bufer);
       lv_strtmp := substr(line_bufer, 1,10);
       :blk_text.txt_content := :blk_text.txt_read_err || lv_strtmp;
       text_io.Fclose(in_file);
  END;
  2.WHEN-BUTTON-PRESSED(to write): thown an exception
  DECLARE
            out_file text_io.file_type;
            line_bufer varchar2(80);
            lv_strtmp varchar2(100);
            lv_content varchar2(100);
            errnum NUMBER := ERROR_CODE;
            errtxt VARCHAR2(80) := ERROR_TEXT;
            errtyp VARCHAR2(3) := ERROR_TYPE;
  BEGIN
       message(‘111’,acknowledge);
            out_file := text_io.fopen(‘/home/cn01278/abc.txt’, ‘w’);
            message(‘222’,acknowledge);
            text_io.put(‘123’);
            text_io.new_line;
            text_io.put_line(out_file, ‘abcd…’);
       text_io.fclose(out_file);
  END;
  3.ON-ERROR Trigger
  DECLARE
       errnum NUMBER := ERROR_CODE;
       errtxt VARCHAR2(80) := ERROR_TEXT;
       errtyp VARCHAR2(3) := ERROR_TYPE;
  BEGIN
  message(‘error:’,acknowledge);
       Message(errtyp||’-‘||TO_CHAR(errnum)||’: ‘||errtxt,acknowledge);
       —:blk_text.txt_err := errtyp||’-‘||TO_CHAR(errnum)||’: ‘||errtxt;
       text_io.fclose(out_file);
       RAISE Form_Trigger_Failure;
  END;
  ————————————————————————————

  Thanks for attension.
  the problem is resolved, it’s a access/right problem with the file(abc.txt).
  after i change the file permission from rwxr—r— to rwxrw-rw-, then it works fine.
  But I have some confuse about it.
  1.The file must exist firstly. if not, then read or wirte the file will cause the ORA-302000 error. Can the file not exist? Can anyone tell me how to create file(abc.txt) with text_io if the file not exist.
  2.If the file was created by A, and A have rw rights, but the group owner have no rw rights, then you run the form by A(connect DB by A), it would cause ORA-302000 error too(both read and write).Why the group owner must have rw rights, or the form can not works fine?
  By the way, my DB account and my App server(Linux) account are same(both A).

• ORA-302000 Error On client_text_io.fopen()

  i am using a webutil library — client_text_io.fopen() on the form that was compiled on 10.1.2.3 version and this webutil_file.file_selection_dialog() built-in package. the webutil_file.file_selection_dialog() works but not the client_text_io.fopen(). when the form is run on the application server it is getting this error ORA-302000.
  PROCEDURE prc_load_proj_alloc_data IS
    vFilename             VARCHAR2(100) := :control.drv_filename;
    vInputFile             client_text_io.FILE_TYPE;
    vLinebuf               VARCHAR2(2000);
    vCommaPosition     NUMBER := 0;
    TYPE                array_type IS VARRAY(10) OF VARCHAR2(100);
    vColumn            array_type := array_type(»);
    vCtr                  BINARY_INTEGER := 1;
    vRowCtr            number := 0;
    vLineLoadCnt     number := 0;
  begin
    — cursor must be placed on the block
    go_block(‘MRC_PROJ_ALLOC_INTERFACE’);
    go_item(‘MRC_PROJ_ALLOC_INTERFACE.ATTRIBUTE1’); 
    —extend and initialize the array to 9 columns
    vColumn.EXTEND(9,1);
    — open the file for reading
    begin
      vInputFile := client_text_io.fopen(vFilename,’r’);
    exception
         when others then
           alertme(‘note’,’SQLCODE ‘||SQLCODE);
           if SQLCODE = -302000 then
                alertme(‘note’,errtyp||’-‘||TO_CHAR(errnum)||’: ‘||errtxt);
          loop
            alertme(‘note’,TO_CHAR(TOOL_ERR.CODE) || ‘: ‘ || TOOL_ERR.MESSAGE);
            TOOL_ERR.POP;
            exit when TOOL_ERR.NERRORS = 0;
          end loop;
        end if;
    end;
  end;
      the file that i am trying to read is in csv format and is not currently in use. i tried any other file from my local C:\ or D:\ drive and i am getting the same error. what could possiblly that i am missing? thanks.

  we figured it out that the cause of issue was that the webutil.plx was on our application executable directory. basically we have the webutil.plx on a common directory applicable to other application and when we removed the webutil.plx on our application directory the ORA-302000 error was solved.

• ORA-302000 error

  I am getting a error ORA-302000 which is not showing in Oracle documentation help from my Developer form. Please help.
  regards.

  we figured it out that the cause of issue was that the webutil.plx was on our application executable directory. basically we have the webutil.plx on a common directory applicable to other application and when we removed the webutil.plx on our application directory the ORA-302000 error was solved.

• URGENT : ORA 302000 when using TEXT_IO.fopen

  Hi,
  I get this error ORA 302000 when using TEXT_IO package, the code I use is
  new_file:=text_io.fopen(‘c:\text.txt’,’r’)
  i don’t have the description of this ORA 302000 , pls does anyone have it?

  Hi,
  I know it’s been 2 years but it’s still up to date for me.
  I tried the suggested piece of code to trace the error but it did not bring anything more
  EXCEPTION
  When Others then
  srw.Message( 2, ‘EXCEPTION ‘ || SQLCODE || ‘ in common package. Can not open the file ‘);
  IF SQLCODE = -302000 then
  LOOP
  EXIT WHEN TOOL_ERR.NERRORS = 0;
  SRW.MESSAGE( 667, TO_CHAR(TOOL_ERR.CODE) || ‘: ‘ || TOOL_ERR.MESSAGE);
  TOOL_ERR.POP;
  END LOOP;
  END IF;
  srw.Message( 3, ‘EXCEPTION ‘ || SQLCODE || ‘ in com package. Can not open the file ‘ || I_Desname || ‘ : ‘ || SQLERRM );
  Only Message 2 and 3 are displayed in the trace file
  Any other suggestion?
  Manu

• ORA-29536: badly formed source

  Hi,
  I have created a Java source in Oracle ,actually i created it using pl/sql developer,
  now i need to deliver it to client ,so i gave it in .sql file ,but then its giving the error
  ora-29536: badly formed source: Encountered «<EOF>» at line 1, column 17.
  following is the source code
  create or replace and compile java source named filelist as
  import java.io.*;
  import java.sql.*;
  import java.util.*;
  public class filelist
  public static void getList(String directory)
  throws SQLException
  try
  File dir = new File(directory);
  System.out.println(«Coming after creating object»);
  File[] files = dir.listFiles();
  System.out.println(«Coming after getting list»);
  Arrays.sort(files, new Comparator() {
  public int compare(Object o1, Object o2) {
  File f1 = (File) o1; File f2 = (File) o2;
  return (int) (f1.lastModified() — f2.lastModified());
  // String[] list = files.list();
  System.out.println(«Coming after sorting1 «+files.length);
  String element;
  for(int i = 0; i < files.length; i++)
  element = files.getName();
  System.out.println(«Coming after «+element);
  #sql { INSERT INTO DIR_LIST (FILENAME,sequence_number)
  VALUES (:element,:i) };
  catch(Exception e)
  System.out.println(e.getMessage());
  please tell me how to get rid of this error ,or is there any there way of loading it into oracle.
  Regards,
  Sandeep

  Yes , I have put ; for each Java statement.
  issue in ; as it’s used as sql terminator, ends the compilation at ;
  How to resolve this, I ahev to give this as sql file.
  How to change the terminator, compile the code, and reset the terminator
  Suggestions are welcome

• Occasional ora-6502 using forms 6i and 10g

  Hi all.
  We have been experiencing some weird and unexpected ora-6502 errors in some of our forms 6i modules running against 10g (rel 1 or 2).
  Forms modules are correctly functioning and for some reason, one day an ora-6502 error suddenly pops up.
  Now the weirdest thing is that after you put some messages on the trigger, so you can track down where the error is coming from, it disappears.
  I know that this may sound hard to believe, but it has happened several times. All we do is put some message built in, recompile all, and the error is gone (for a while).
  So my questions are:
  — Is this a known issue beween forms 6i and 10g Db?.
  — Is there a patch on Metalink ( we use Forms [32 bits] Versión 6.0.8.26.0 (Producción))
  — A workaround?
  and most important
  — Have anyone been exposed to a similar situation?
  Regards, Luis …!

  Now the weirdest thing is that after you put some messages on the trigger, so you can track down where the error is coming from, it disappears.Sounds like the form has not been «clean compiled» against the server on which it is running. Try a «Compile All», which causes all previously compiled program units to be compiled fresh.
  Or even better, clean out all the compiled code from your fmb before compiling the fmb on the server where it runs.
  See this topic:   Re: Why does this happen — find ‘;’, replace with ‘;’?

• Ora -06502 from forms application

  I have medical application developed by forms 9i, But its responds error
  ORA-06502 while running a form with enter query mode. it displys the said
  error while execute the query . I dont the exeact SQL query returns this error. How to debug this? Is there any way how to find the sql text returns this error. Kinldy note that, I dont have the forms source code. Only executable available(fmx). I have TOAD too. can i use the toad to traceout it.
  thanks.

  Hi,
  This is ‘ numeric or value error’ it may be character to number conversion problem or your assigning character value to number field in the form…..But without source code It’s not easy to solve the problem….
  Thanks,
  Pavan.

• Error ORA-06502: FROM forms

  I have medical application developed by forms 9i, But its responds error
  ORA-06502 while running a form with enter query mode. it displys the said
  error while execute the query . I dont the exeact SQL query returns this error. How to debug this? Is there any way how to find the sql text returns this error. Kinldy note that, I dont have the forms source code. Only executable available(fmx). I have TOAD too. can i use the toad to traceout it.
  thanks.

  Its an application error.If you don’t have the source code,you need to ask for the source code.

• Ora-01843 when Form is based on procedure

  I create a page using form based on procedure option. I have a date picker item in the form that corresponds to a date parameter in the procedure.
  I select every date format APEX provided from APEX date picker and always got ora-01843(not a valid month) error when I tried to sumbit the form.
  I have changed PICK_DATE_FORMAT_MASK to DD/MM/YYYY at application level but cannot solve the problem.
  Does anyone using a «Form on Procedure» and happen to have a date column? Do you have similar problem?
  ps. this problem only occurs to «Form on Procedure». I have no problem with master details or many other form options. I am using APEX 3.1.

  Hello user3003555,
  I have created forms based on procedure and used date pickers on them but don’t recall encountering the date format error ORA-1843. I used «Date Picker (DD-MON-YYYY)» which corresponds to my application date format. I’m not sure what else I can tell you. Have you tried picking a date where the month and day are interchangeable to confirm that it is a formatting issue?
  — Alwyn

• Compiling error ORA-00600 with Forms 6 and Database 10g

  Hi,
  I am using «Oracle Database 10g Enterprise Edition Release 10.1.0.4.0» and «Forms [32 Bit] Version 6.0.8.26.0 » with patch 17, when i compile a form that works with some tables in another database under dblink the error ORA-00600:internal error code, arguments:[16203],[],[],[],[],[],[],[] is displayed.
  If i word with reports or sqlplus no error is displayed.
  Before we installed 10g everything worked ok
  What is wrong with forms or do i need to configure something else?
  Regards
  Yuri V. López Manrique

  I searched for this error on Google and found the following blog:
  Is there a tool to troubleshoot ORA-00600 and ORA-07445 errors?
  February 27th, 2006 By Fahd Mirza
  ORA-00600 and ORA-07445 errors are the most esoteric errors in Oracle.
  There is a tool called “ORA-600/ORA-7445 Troubleshooter” available at Metalink. It asks for the first argument of ORA-600 error with an optional database version number.
  For example, to see the description of the error:
  ORA-00600: internal error code, arguments: [723], [25908], [25908], [memory leak]
  You enter 723 in the “ORA-600 First Argument” field. The first argument is a pointer to where in the code the error was caught and thus is the key information in identifying the problem.
  You can also embed (copy/paste) the “Call Stack Trace” there, and, when you click on the “Search Call Stack” button an advanced MetaLink search is performed to find documents containing relevant sections from the call stack.
  Call Stack extracts from the following files are supported:
  * Generic foreground and background server trace files located in background_dump_dest and user_dump_dest
  * OpenVMS NETV2 and BEQ log files located in ORA_ROOT:[NETWORK.LOG]
  * WINDOWS CORE.LOG files
  * GDB (debugger) backtrace call stacks (best endeavors)
  Of course you will need a login to Oracle’s Metalink site.
  Hope that helps,
  c

• ORA-01001 in Form Based on Stored Proc.

  I’m getting ORA-01001 when the form passes parameters
  to the stored procedure:
  Error Executing Cursor
  SQL:
  begin
  «ABSUSR».»P_PORTAL_RPTS1″ ( P_RPT_NAME => ‘Print1’,
  P_ST_DATE => ’01-OCT-01′, P_EN_DATE => ’04-JUN-02′,
  P_FORMAT => ‘HTML’, P_ROWS => ‘250’);
  end;
  ORA-01001: invalid cursor
  I can’t see anything wrong with the parameters, and
  the procedure works fine by itself. I also get a
  script error when running the form as a portlet,
  by itself, or in a page: «A runtime error has
  occured: do you wish to debug? Line 2 Expected «(«
  But there is nothing obviously wrong with the
  html that’s presented for debugging. I have
  searched for 1001 at Metalink and Portal Studio,
  and found note 1007395.6 Common Causes of 1001.
  I don’t see that error checking is an issue,
  and my OPEN_CURSORS is set to 300.
  any thoughts or experience?
  thanks and best wishes, Jon Angel HHS/PSC

  Hi Jon ,
  Can you explain your requirement in more detail as I’m not getting what may be wrong by your query.Please let me know what type of procedure is it.
  and also please tell in what circumstances are u getting error when you make a portlet.
  It will be nice if you can make a full test case of your requirement.
  Hope to get details from you.
  rahul

• Suppressing ORA-1403 in Forms 6i

  We are running FORMS 6i and I am creating a library function that will do various types of lookups and then behave in specific ways based on passed parameters.
  How can I over-ride the default ORA-1403 when no records are found in the query?
  Thanks

  Use nested begin-exception-end blocks within the pl/sql code in your pll libraryFunction PLL_Lookup(params in varchar2)
    Return varchar2 is
    variables here;
    Result  varchar2(100);
  Begin
    — for each select you want, create a nested block:
    Begin
      select….
      Exception when no_data_found then…. ;
    End;
    — more pl/sql here
    — Maybe another Begin — Exception — End here…
    Return result;
  End;

• ORA-06508 in Forms Debugger

  Windows 2000
  Forms 6i Patch 5a
  9i Database
  I have a form that generates a ORA-06508 when in the debugger only. It runs fine else (running in the builder, client-server or web.)
  I have detached the library. Shift+Ctrl+K’d the form. Saved the form. Closed the form. Recompiled the attached library using the forms compiler. Opened the form, reattached the library, SHIFT+Ctrl+K’d the form, and the same thing occurs. I want to stress this occurs only when running in the debugger.
  Any ideas or suggestions?
  Thanks
  -Chris

  In that case you probably have two copies of a library around. In normal runtime a PLX file will always be used in preference to a PLL. In Debug mode PLX files will be ignored and the PLL only used.

• ORA-06508,ORA-06512, why I should re-connect and after that it runs well?

  I have 2 package.
  package A depends on B.
  I call the package A in c++ code. At the begining, all work well.
  I compile package B successfully.
  But when I call package A in c++ code using a existing connection to the oracle, I get
  ORA-06508: PL/SQL:
  ORA-06512: 在 «PARTY.PKG_TRANSACTION», line 102
  ORA-06512: 在 «PARTY.PKG_CFMMC», line 1186
  when I kill this session in database server side and re-connect to the database, it runs well.
  what is wrong, why I should re-connect and then it runs well, and in the mean time, it does raise errors above if I use the old connection?

  It appears sometimes. But sometimes it does not appear.
  you can create 2 package.
  package a, package b.
  A depends on b.
  You can call the package A in the client side using c++ code.
  then compile the b(do not change and code of b, just recompile it) successfully.
  If you are lucky you can see the errors.