Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1210
  • Last Modified:

PL/SQL

What  is syntaxtically wrong with this code? I am having the following error:

Error 49 at line 4, column 4
bad bind variable 'PARAMETER.P_1'

THE CODE:
=======
declare
v_where varchar2(100);
begin
IF :PARAMETER.P_1 IS NOT NULL THEN
v_where := :PARAMETER.P_1;
set_block_property('student', default_where, v_where);
execute_query;
--
set_block_property('student', default_where, '');
go_block('enrollment');
end if;
end;
0
achille67
Asked:
achille67
  • 3
  • 2
1 Solution
 
pennnnCommented:
It seems you haven't created the P_1 parameter...
0
 
seazodiacCommented:
what's PARAMETER.P_1?
0
 
achille67Author Commented:
PARAMETER.P_1 is  a built in variable so i don't need to create it
0
Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

 
pennnnCommented:
You need to create a Form Parameter named P_1 in order to be able to refer to it in the code. It is not built-in. You have to create it hte way you create a block, canvas, etc.
0
 
achille67Author Commented:
Thanks pennn
Now i having the following error when trying to compile the form
do u know why?

Block: STUDENT
Form: ENROLL_INFO
FRM-30085: Unable to adjust form for output.
0
 
pennnnCommented:
The most common case for that error is when you already have the form running, so it can't generate it again, because the fmx is being used... The message is a bit misleading... :-)
0

Featured Post

Learn Veeam advantages over legacy backup

Every day, more and more legacy backup customers switch to Veeam. Technologies designed for the client-server era cannot restore any IT service running in the hybrid cloud within seconds. Learn top Veeam advantages over legacy backup and get Veeam for the price of your renewal

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now