Results 1 to 5 of 5
  1. #1
    Join Date
    Mar 2004
    Posts
    5

    Exclamation Unanswered: Create type as table of rowids

    Hi,

    I try to create a new TYPE as table of ROWIDs in order to pass it as argument in a procedure.

    I tried the following:

    CREATE OR REPLACE TYPE rowid_table AS TABLE OF ROWID INDEX BY BINARY_INTEGER;

    The error message returned is the following:
    PLS-00355: use of pl/sql table not allowed in this context

    Can someone help me with this?

    Thanx a lot!

  2. #2
    Join Date
    Feb 2004
    Posts
    6
    Hi,

    Are you trying to create this within a PL/SQL block or for a user?

    Regards,
    Jitendra Agrawal

    http://www.telemune.com/ Missed Call Alerts

  3. #3
    Join Date
    Mar 2004
    Posts
    5
    I create this type to be used in several procedures.
    In fact I'm making a pl/sql script to clean tables.

    As I want it to be 'universal' the script needs to delete records using their rowid.
    It means that ,in the main script, I perform a select that returns the needed rowids. I store them in a table of rowids. I need to pass it to the Purge script.

    CREATE OR REPLACE PROCEDURE purger_enfant(
    name_tab IN VARCHAR2,
    rowid_tab IN ROWID_TABLE
    ) AS
    ...

    Hope this is clear...

    Thank you!

  4. #4
    Join Date
    Feb 2004
    Posts
    6
    Hi,

    Please consider defining type in package definition.

    Regards,
    Jitendra Agrawal.

    Missed Call Alerts

  5. #5
    Join Date
    Mar 2004
    Posts
    5
    Thanks!
    I'll try.

    Cheers

Posting Permissions

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