Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2004
    Location
    Germany
    Posts
    136

    Unanswered: Some questions about creation of ErrorLog

    Hello All!

    I have the following code of my Error_Handling:
    PHP Code:
    ..
    ErrorCode := SQLCODE;
    ErrorMsg := SQLERRM;
    ErrorText := SUBSTR(SQLERRM1200);

    ErrorForm := 'PROCEDURE';
    ProcName : = 'PRC_TEST';
    Param := 'varTest';

    INSERT INTO ERRORLOG ERROR_CODE
                             
    ERROR_FORMPROC_NAMEPARAM
                             
    ERROR_MSGERROR_TEXT)
                       
    VALUESErrorCode
                             
    ErrorFormProcNameParam
                             
    ErrorMsgErrorText);                
    .. 
    Now i want to generate ErrorForm, Param and ProcName dynamically like ErrorCode , ErrorMsg , ErrorText .

    How can i realize it?
    Are there some functions like SQLCODE, SQLERRM.?


    Thanks in advance!
    Last edited by julla27; 06-07-04 at 11:14.
    Regards,
    Julia

  2. #2
    Join Date
    Sep 2002
    Location
    UK
    Posts
    5,171
    Provided Answers: 1
    You may find this useful:

    http://asktom.oracle.com/~tkyte/who_..._me/index.html

    However, I'm not sure what you mean by "ErrorForm" and "Param". If you are using Oracle Forms, then YSTEM.CURRENT_FORM may be what you want.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •