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
LVL 1
samir25Asked:
Who is Participating?
 
JimBrandleyConnect With a Mentor Commented:
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
Cloud Class® Course: Ruby Fundamentals

This course will introduce you to Ruby, as well as teach you about classes, methods, variables, data structures, loops, enumerable methods, and finishing touches.

 
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
 
DhaestConnect With a Mentor Commented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.