Get Help:Ask a Question in our Forums|Report a Bug|More Help Resources
Last post Aug 07, 2012 05:28 PM by indianapolymath
Aug 07, 2012 12:14 PM|LINK
I am updating an Oracle stored procedure and I want to test parts of this large proc before making the changes.
I can do the following and get results:
SELECT * FROM table_name WHERE column_name_in_table = '1234'
But when this goes to production, the hard coded number will be a variable but when I do the following:
p_userid char(8 BYTE) := '1234';
SELECT * FROM table_name WHERE column_name_in_table = trim(p_userid)
I get an error: ORA-00904: "P_USERID": invalid identifier
00904. 00000 - "%s: invalid identifier"
What is the easiest way to see a select statement results in Oracle?
Aug 07, 2012 01:35 PM|LINK
when defining p_userid try using number or varchar instead of char(8 BYTE)
Aug 07, 2012 05:19 PM|LINK
Help a guy out here :-)
So can I take it from the silence that there is not a good way to unit test code before updating a whole procedure or package? Say it isn't so!
Aug 07, 2012 05:28 PM|LINK
Figured it out...needed the keyword "variable" in front