ORA-01008
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: ORA-01008

  1. #1
    Join Date
    Feb 2001
    Posts
    107
    I am getting ORA-01008 when running the following script. any help to get it to work will be appreciated.

    Thanks in advance

    SELECT f.file_name, ROUND (f.bytes / 1024 / 1024, 2),
    f.blocks, f.autoextensible, ROUND (x.inc, 0), f.maxbytes, f.maxblocks,
    f.status, x.maxextend, f.file_id
    FROM sys.dba_data_files f, sys.filext$ x
    WHERE f.tablespace_name = :tname
    AND x.file#(+) = f.file_id

    ORA-01008: not all variables bound


  2. #2
    Join Date
    Sep 2001
    Posts
    112
    you are using bind variables like you would in forms.

    This isn't right, are you trying to achieve user input parameters in you script?

Posting Permissions

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


Click Here to Expand Forum to Full Width