Home » RDBMS Server » Server Administration » Another migration syntax problem
Another migration syntax problem [message #372182] Wed, 17 January 2001 17:32 Go to next message
elsie reed
Messages: 7
Registered: January 2001
Junior Member
i had a lookup in my etl package that worked with ms sql but won't work with oracle 8i.

SELECT COMPANY_CODE_ID
FROM COMPANY_CODE
WHERE COMPANY_CODE_DESC = ?

i get this message
"the provider cannot derive parameter info and setparameter info has not been called"

how do i get it to work with oracle?

thank all of you for ur help.

Report message to a moderator

Re: Another migration syntax problem [message #372191 is a reply to message #372182] Thu, 18 January 2001 10:01 Go to previous messageGo to next message
Suresh Vemulapalli
Messages: 624
Registered: August 2000
Senior Member
Hi,
Are you running this query from SQLPLUS or any frontend tool?.

Suresh

Report message to a moderator

Re: Another migration syntax problem [message #372195 is a reply to message #372182] Thu, 18 January 2001 10:53 Go to previous message
elsie reed
Messages: 7
Registered: January 2001
Junior Member
From MS sql 7 DTS Package

Report message to a moderator

Previous Topic: How can I dop Index
Next Topic: Script on Creating tables
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed May 15 14:45:48 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.