Hello,
I am running into a qualified object problem. I have a .net program that calls a stored procedure. I pass an entire SQL statement to the procedure as a parm. When I build the SQL statement in the .net program, I have been using the LIBRARY.TABLE notation and I'm getting the following error
Message . . . . : Qualified object name CONVRPF not valid.
Cause . . . . . : One of the following has occurred:
-- The syntax used for the qualified object name is not valid for the
naming option specified. With system naming, the qualified form of an
object name is schema-name/object-name. With SQL naming the qualified form
of an object name is authorization-name.object-name.
-- The syntax used for the qualified object name is not allowed.
User-defined types cannot be qualified with the schema in the system naming
convention on parameters and SQL variables of an SQL procedure or function.
Recovery . . . : Do one of the following and try the request again:
-- If you want to use the SQL naming convention, verify the SQL naming
option in the appropriate SQL command and qualify the object names in the
I tried changing the notation to LIBRARY/TABLE but get the same error. Not sure what is going on here. The object exists in the library that is coded in the SQL statement.
Any ideas what is happening here? I checked the naming convention used by the connection and it is SQL.
Thank you,
Antonio Mira
Application Developer - Mid-Ohio Division
Time Warner Cable
1015 Olentangy River Road - 2nd Floor
Columbus, OH 43212
http://www.timewarnercable.com
phone: 614 827 7949
This E-mail and any of its attachments may contain Time Warner
Cable proprietary information, which is privileged, confidential,
or subject to copyright belonging to Time Warner Cable. This E-mail
is intended solely for the use of the individual or entity to which
it is addressed. If you are not the intended recipient of this
E-mail, you are hereby notified that any dissemination,
distribution, copying, or action taken in relation to the contents
of and attachments to this E-mail is strictly prohibited and may be
unlawful. If you have received this E-mail in error, please notify
the sender immediately and permanently delete the original and any
copy of this E-mail and any printout.
As an Amazon Associate we earn from qualifying purchases.