[an error occurred while processing this directive] [an error occurred while processing this directive][an error occurred while processing this directive] [an error occurred while processing this directive] [an error occurred while processing this directive] [an error occurred while processing this directive] (none) [an error occurred while processing this directive] [an error occurred while processing this directive] [an error occurred while processing this directive] [an error occurred while processing this directive] [an error occurred while processing this directive][an error occurred while processing this directive] [an error occurred while processing this directive][an error occurred while processing this directive] [an error occurred while processing this directive][an error occurred while processing this directive] [an error occurred while processing this directive] [an error occurred while processing this directive] [an error occurred while processing this directive] (none) [an error occurred while processing this directive] [an error occurred while processing this directive] [an error occurred while processing this directive][an error occurred while processing this directive]
 
[an error occurred while processing this directive] [an error occurred while processing this directive]
Skåne Sjælland Linux User Group - http://www.sslug.dk Home   Subscribe   Mail Archive   Forum   Calendar   Search
MhonArc Date: [Date Prev] [Date Index] [Date Next]   Thread: [Date Prev] [Thread Index] [Date Next]   MhonArc
 

oracle problem



Hejsa,
  Der skulle vel ikke være nogle oracle eksperter, som kan se fejlen i
nedenstående ?
Jeg fatter det simplethen ikke.


SQL> !cat formtype.pkg
CREATE OR REPLACE PACKAGE formtype AS
  FUNCTION get_formtype (job_id IN NUMBER) RETURN VARCHAR2;
  PROCEDURE set_formtype (job_id IN NUMBER);
END;
/

CREATE OR REPLACE PACKAGE BODY formtype AS

  FUNCTION get_formtype (job_id IN NUMBER) RETURN VARCHAR2 IS
    result VARCHAR2(2000);
  BEGIN
    result:=opdd.obj_job.initialise(job_id,1);
    IF (result='Success') THEN
      RETURN opdd.obj_job.form_type;
    ELSE
      RETURN NULL;
    END IF;
  END;

  PROCEDURE set_formtype (job_id IN NUMBER) IS
    result VARCHAR2(2000);
    f_id NUMBER;
  BEGIN
    result:=opdd.obj_job.initialise(job_id,1);
    IF (result='Success') THEN
      SELECT id INTO f_id FROM formtypes WHERE formtype=opdd.obj_job.form_type;
      UPDATE tickets SET formtype=f_id;
      COMMIT;
    ELSE
      NULL;
    END IF;
  END;

END;
/


SQL> @formtype.pkg

Package created.


Warning: Package Body created with compilation errors.

SQL> show errors
Errors for PACKAGE BODY FORMTYPE:

LINE/COL ERROR
-------- -----------------------------------------------------------------
6/5      PL/SQL: Statement ignored
6/13     PLS-00201: identifier 'OPDD.OBJ_JOB' must be declared
8/7      PL/SQL: Statement ignored
8/14     PLS-00201: identifier 'OPDD.OBJ_JOB' must be declared
18/5     PL/SQL: Statement ignored
18/13    PLS-00201: identifier 'OPDD.OBJ_JOB' must be declared
SQL> desc OPDD.OBJ_JOB

FUNCTION AUTOMATIC_DESPATCH RETURNS VARCHAR2
FUNCTION AUTOMATIC_PRE_DESPATCH_PROCESS RETURNS VARCHAR2
FUNCTION AUTOMATIC_PRE_PRINT_QA RETURNS VARCHAR2
FUNCTION AUTOMATIC_PRINT RETURNS VARCHAR2
FUNCTION AUTOMATIC_PROCESS RETURNS VARCHAR2
FUNCTION AUTOMATIC_REPRINT_PROCESS RETURNS VARCHAR2
[...]


 
Home   Subscribe   Mail Archive   Index   Calendar   Search

 
 
Questions about the web-pages to <www_admin>. Last modified 2008-01-01, 17:38 CET [an error occurred while processing this directive]
This page is maintained by [an error occurred while processing this directive]MHonArc [an error occurred while processing this directive] # [an error occurred while processing this directive] *