We help IT Professionals succeed at work.

We've partnered with Certified Experts, Carl Webster and Richard Faulkner, to bring you two Citrix podcasts. Learn about 2020 trends and get answers to your biggest Citrix questions!Listen Now

x

URGENT-ORA-00905:missing keyword

samir25
samir25 asked
on
Medium Priority
1,464 Views
Last Modified: 2013-12-07
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
Comment
Watch Question

Top Expert 2007
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

Not the solution you were looking for? Getting a personalized solution is easy.

Ask the Experts

Author

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
Top Expert 2007

Commented:
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.

Author

Commented:
ok i will close this thread
thanks
Top Expert 2007

Commented:
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

Author

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
Top Expert 2007

Commented:
OK - Thanks. Good luck with the rest.
Dirk HaestProject manager
CERTIFIED EXPERT
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
Dirk HaestProject manager
CERTIFIED EXPERT

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
Access more of Experts Exchange with a free account
Thanks for using Experts Exchange.

Create a free account to continue.

Limited access with a free account allows you to:

  • View three pieces of content (articles, solutions, posts, and videos)
  • Ask the experts questions (counted toward content limit)
  • Customize your dashboard and profile

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.