Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2002
    Location
    San Francisco, CA
    Posts
    441

    Unanswered: ORA-01027: bind variables not allowed for data definition operations

    I keep getting this error in a sql script
    ORA-01027: bind variables not allowed for data definition operations
    I know why it is doing it, I just want to get round it somehow; any suggestions?

    Here is the bit causing problems:
    Code:
    create table x.temp1 (x,y,z,minRowID,Count)
    	as
    	(
    	SELECT a.x,a.y,a.z,min(a.rowid),count(*)
    	from x.a a
    	where a.x=:blahbindvariable
    	group by a.y,a.z,a.x
    	having count(*)>1
    	);
    Any help is greatly appreciated!

  2. #2
    Join Date
    Apr 2001
    Location
    Netherlands
    Posts
    191
    Maybe a workaround:
    Why not create the table, and then insert into table select ...

    ?
    Ruud Schilders
    -----------------
    Oracle DBA
    e-mail : ruud@schilders.it
    URL : www.schilders.it
    Twitter : www.twitter.com/ruudschilders

  3. #3
    Join Date
    Feb 2002
    Location
    San Francisco, CA
    Posts
    441
    It worked! Nice work around...heres me trying to do it in the smallest amount of code...

    thanks ruud

Posting Permissions

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