|
-
First, the passing parameters:
.................
(p_table_id VARCHAR2(50),
p_column_id VARCHAR2(50)) will give warning error( not fatal error) while compiling the procedure, so they should be:
.................
(p_table_id VARCHAR2,
p_column_id VARCHAR2)
Second, the select....... into ........ statements will return more than one rows that satisfy the condition probably, but I'm not sure this is the exact reason for the error occurred, I don't know what are the "---------" means in the two "select into" statements.
Take care
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|
Reply With Quote