samir25
asked on
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
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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.
ASKER
ok i will close this thread
thanks
thanks
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
Jim
ASKER
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
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
OK - Thanks. Good luck with the rest.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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
More information about select into: http://www.w3schools.com/sql/sql_select_into.asp
ASKER
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