SQL Function call - VisualCron

Please note that VisualCron support is not actively monitoring this community forum. Please use our contact page for contacting the VisualCron support directly.

Welcome Guest! To enable all features please Login or Register.

trevinom
No customer Topic Starter

2012-08-09T13:47:44Z

Can you help me in figuring out how to issue a function call?
The call I'm trying to replicate is the following:

l_return_value := fn_send_rp140("schedule_id");

The returned value is '0' or '1'.

Sponsor

Forum information

Wanna join the discussion?! Login to your Forum forum account or Register a new forum account

Support
Official support

2012-08-09T13:51:55Z

You should be able to call this with the SQL Text command. Have not tried it though but it should look something like this:

SELECT dbo.FunctionName([Parameter1, Parameter2])

or like this:

DEFAULT (dbo.udfMyFunction('SomeParam','OtherParam'))

Henrik
Support
http://www.visualcron.com
Please like VisualCron on facebook!

trevinom
No customer Topic Starter

2012-08-09T14:57:38Z

It's not working. It's giving me the following error:

Exception in Task: ORA-06550: line 3, column 5:
PLS-00221: 'FN_SEND_RP240' is not a procedure or is undefined
ORA-06550: line 3, column 5:
PL/SQL: Statement ignored

This is what I'm using:

begin
fn_send_rp240('schedule_id');
end;

trevinom
No customer Topic Starter

2012-08-09T15:06:06Z

It would be really nice if the SQL task had Functions and Packages as in the attached picture.

trevinom attached the following image(s):

Support
Official support

2012-08-09T16:43:37Z

I was able to execute a function I created like this:

select dbo.FunctionName()

Henrik
Support
http://www.visualcron.com
Please like VisualCron on facebook!

trevinom
No customer Topic Starter

2012-08-09T18:20:07Z

Can you put in the name the code you used rather than the generic version of the command?
I might be missing something basic here. I keep getting the error:

Exception in Task: ORA-00923: FROM keyword not found where expected