|
|
|
Re: Package Define problem [message #587688 is a reply to message #587687] |
Tue, 18 June 2013 02:34 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/72104.gif) |
Littlefoot
Messages: 21818 Registered: June 2005 Location: Croatia, Europe
|
Senior Member Account Moderator |
|
|
Yes, you DO use parameters. One, actually:
It seems that you didn't understand what Michel said. Package specification & body MUST match.
package folders is
procedure define (block in varchar2); --> this ...
...
package body folders is
procedure define (block in varchar2) is --> ... and this must match
...
[Updated on: Tue, 18 June 2013 02:36] Report message to a moderator
|
|
|
|
|
|
|
Re: Package Define problem [message #587746 is a reply to message #587744] |
Tue, 18 June 2013 06:24 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/72104.gif) |
Littlefoot
Messages: 21818 Registered: June 2005 Location: Croatia, Europe
|
Senior Member Account Moderator |
|
|
You didn't provide procedure's parameter value. As you created is aspackage folders is
procedure define (block in varchar2); then you have to call it the same way:
folders.define('some_value_goes_here');
|
|
|