Results 1 to 8 of 8

Thread: procedure

  1. #1
    Join Date
    Oct 2003
    Posts
    15

    Unanswered: procedure

    i m trying to call a procedure from sql plus

    SQL> select object_name,object_type,status
    2 from user_objects
    3 where status='INVALID';

    OBJECT_NAME
    ---------------------------------------------------------
    OBJECT_TYPE STATUS
    ------------------ -------
    BUILD_CARGO_TANK_DUMP
    PROCEDURE INVALID

    IDX_ANALIZE
    PROCEDURE INVALID


    SQL> execute build_cargo_tank_dump;
    BEGIN build_cargo_tank_dump; END;

    *
    ERROR at line 1:
    ORA-06550: line 1, column 7:
    PLS-00905: object HMIS.BUILD_CARGO_TANK_DUMP is invalid
    ORA-06550: line 1, column 7:
    PL/SQL: Statement ignored

  2. #2
    Join Date
    Apr 2003
    Location
    Greenville, SC (USA)
    Posts
    1,155
    sql> alter procedure BUILD_CARGO_TANK_DUMP compile;

    Then you should be able to execute it ...

    HTH
    Gregg

  3. #3
    Join Date
    Oct 2003
    Posts
    15
    SQL> alter procedure BUILD_CARGO_TANK_DUMP compile;

    Warning: Procedure altered with compilation errors.

    thats what i m getting

  4. #4
    Join Date
    Sep 2003
    Posts
    16
    Can you get hold of the source for this procedure and attempt to compile it manually? There's obviously a problem with the code somewhere that you'll need to debug.

  5. #5
    Join Date
    Oct 2003
    Posts
    15
    how do i find the source?

  6. #6
    Join Date
    Apr 2003
    Location
    Greenville, SC (USA)
    Posts
    1,155
    SQL> alter procedure BUILD_CARGO_TANK_DUMP compile;

    Warning: Procedure altered with compilation errors.

    sql> SHOW ERRORS

    Will return you the error ...
    The attached script will pull the actual procedure and create
    a file for you to edit ...

    Change the spool directory and run .. currently to c:\1_proc.sql

    HTH
    Gregg
    Attached Files Attached Files

  7. #7
    Join Date
    Oct 2003
    Posts
    15
    it's coming back with nothing.

    SQL> show error
    Errors for PROCEDURE BUILD_CARGO_TANK_DUMP:
    76/16 PLS-00103: Encountered the symbol "@" when expecting one of the
    following:
    ( - + mod not null <an identifier>
    <a double-quoted delimited-identifier> <a bind variable> avg
    count current exists max min prior sql stddev sum variance
    execute forall time timestamp interval date
    <a string literal with character set specification>
    <a number> <a single-quoted SQL string>
    The symbol "<an identifier>" was substituted for "@" to continue.


    SQL> @c:\gen_proc.sql
    SQL>

  8. #8
    Join Date
    Apr 2003
    Location
    Greenville, SC (USA)
    Posts
    1,155
    gen_proc.sql
    will create you a script file ... I believe currently in
    c:\1_PROC.sql
    At the bottom on gen_proc.sql is a spool statement ... You can change
    the output filename to anything that makes sense to you...

    The procedure script will be in the spooled file ...

    HTH
    Gregg

Posting Permissions

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