Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How execute store procedure steps in VB script

Status
Not open for further replies.

ujwal k

Technical User
Mar 27, 2018
1
0
0
US
How to write below store procedure steps in VB script

declare
l_ns varchar2(40) := null;--'ins:';
l_count number (6);
l_serial_number VARCHAR2(15);
v_quantity number (6);
v_serial_code number (6);
v_lot_code number (6);
procedure log_mesg(p_value in varchar2) is begin
dbms_output.put_line(p_value);
end;

procedure log_mesg(p_field in varchar2, p_value in varchar2) is begin
dbms_output.put_line('<'||l_ns||p_field||'>'||p_value||'</'||l_ns||p_field||'>');
end;
begin
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top