Running Oracle SQL DDL from the IDE
-
I have a Database project in which I put all my DDL code. I have a database connection for this project connecting to an Oracle database. Unlike when I am using SQLServer, my scripts do not run properly when I right click on a script file and say run. If I have a simple select * from table then it runs. However the DDL such as: CREATE TABLE "CMD"."TBL_BLAH" ( "BLAH_ID" VARCHAR2(38) NOT NULL, "DESCRIPTION" VARCHAR2(50) NOT NULL, PRIMARY KEY("BLAH_ID") ) / I get an error saying: ORA-00922: missing or invalid option The same runs on sqlplus. Ok, so now I removed the / and it owrks. But I have a new problem. The DDL is actually: CREATE TABLE "CMD"."TBL_BLAH" ( "BLAH_ID" VARCHAR2(38) NOT NULL, "DESCRIPTION" VARCHAR2(50) NOT NULL, PRIMARY KEY("BLAH_ID") ) GRANT SELECT ON "Q"."TBL_BLAH" TO "BLAH_BLAH"; And now I get the same error again. Anyone know how to set these scripts up so that they can be run from the IDE? Thanks.
-
I have a Database project in which I put all my DDL code. I have a database connection for this project connecting to an Oracle database. Unlike when I am using SQLServer, my scripts do not run properly when I right click on a script file and say run. If I have a simple select * from table then it runs. However the DDL such as: CREATE TABLE "CMD"."TBL_BLAH" ( "BLAH_ID" VARCHAR2(38) NOT NULL, "DESCRIPTION" VARCHAR2(50) NOT NULL, PRIMARY KEY("BLAH_ID") ) / I get an error saying: ORA-00922: missing or invalid option The same runs on sqlplus. Ok, so now I removed the / and it owrks. But I have a new problem. The DDL is actually: CREATE TABLE "CMD"."TBL_BLAH" ( "BLAH_ID" VARCHAR2(38) NOT NULL, "DESCRIPTION" VARCHAR2(50) NOT NULL, PRIMARY KEY("BLAH_ID") ) GRANT SELECT ON "Q"."TBL_BLAH" TO "BLAH_BLAH"; And now I get the same error again. Anyone know how to set these scripts up so that they can be run from the IDE? Thanks.
Which IDE do you mean? Assume that you mean Enterprise manager? "Now I guess I'll sit back and watch people misinterpret what I just said......" Christian Graus At The Soapbox
-
Which IDE do you mean? Assume that you mean Enterprise manager? "Now I guess I'll sit back and watch people misinterpret what I just said......" Christian Graus At The Soapbox
Ah, I should have made myself clear. I meant the VS .Net IDE. The IDE lets you create Database projects and you can execute DDL from the VS .Net IDE itself. Works really well with SQLServer. With Oracle I am having problems as mentioned in my post.
-
Ah, I should have made myself clear. I meant the VS .Net IDE. The IDE lets you create Database projects and you can execute DDL from the VS .Net IDE itself. Works really well with SQLServer. With Oracle I am having problems as mentioned in my post.
Ahhhhh.....don't have an ORA installation here to test, but if manage it, will let you know.... Sorry about that! "Now I guess I'll sit back and watch people misinterpret what I just said......" Christian Graus At The Soapbox