Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1380
  • Last Modified:

URGENT-ORA-00905:missing keyword

hi
my query in asp.net, vb.net page is something like this
"select a,b,c,d into a1,b1,c1,d1 from tablename"

i have declared all the into variables before hand. but i am getting this error
ORA-00905:missing keyword, i feel somehow this is not what it should be in asp.net. in pl/sql i use this but how can i have this query running in asp.net
0
samir25
Asked:
samir25
  • 4
  • 3
  • 2
2 Solutions
 
JimBrandleyCommented:
samir25 - Oracle expects to see a colon in front of bind parameter names. Try:

select a,b,c,d into :a1,:b1,:c1,:d1 from tablename
0
 
samir25Author Commented:
ok it still doesnt work as i come back to the same error.
one of the fields in the database is a clob (xml file). i want to read one small part from that xml file. after i extract that thing from the xml file i want to put in a datagrid column.

i simply did select xmldata from tablename and put that xmldata in the gridview but it threw and error Datatype not supported.so i thought i will define a variable as string and put clob data into string. so now i put :varName and it's the same error i am getting. data type is not supported
0
 
JimBrandleyCommented:
I know Oracle, but I do not know vb.Net. I will post a link to this question in the VB.Net zone to see if I can get you some help.
0
Restore individual SQL databases with ease

Veeam Explorer for Microsoft SQL Server delivers an easy-to-use, wizard-driven interface for restoring your databases from a backup. No expert SQL background required. Web interface provides a complete view of all available SQL databases to simplify the recovery of lost database

 
samir25Author Commented:
ok i will close this thread
thanks
0
 
JimBrandleyCommented:
Samir25 - I posted a link to this question. I just posted another to ask for help in re-opening this question for you. I do not have that ability. I also asked that the points you awarded me be refunded.

Jim
0
 
samir25Author Commented:
hi jim..
at least you helped me remove teh error for what i posted the thread. so i dont see any concerns on u getting the points.

i have already posted another thread on dot net side
0
 
JimBrandleyCommented:
OK - Thanks. Good luck with the rest.
0
 
DhaestCommented:
What do you want to do exactly ? Getting the data out of your database to show it on the screen or create a backup (copy from your table into another table)

More information about select into: http://www.w3schools.com/sql/sql_select_into.asp
0
 
DhaestCommented:
What do you want to do exactly ? Getting the data out of your database to show it on the screen or create a backup (copy from your table into another table)

More information about select into: http://www.w3schools.com/sql/sql_select_into.asp
0

Featured Post

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

  • 4
  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now