Execute procedure through free-hand sql

[shlomi_weiss2]

Hi all

I;m using BO 4.1 sp6 and I try to use the new free-hand feature to execute a simple procedure that returns some data

I get the following error message

Any ideas?

My connection is OLEDB to SQL server 2008

Shlomi

[shlomi_weiss2]

Hi

It seems that with free-hand SQL I can only run procedures that runs selects

When I try to run anything else, I get error messages

Like create table for example

Anyone had similar issues?

Shlomi

[amitrathi239]

Hi,

Script validating is successful?

Check this link.

Amit

[shlomi_weiss2]

Yes it does pass validation

I've read the link and followed it

I have a small update

I've managed to rin A simple select inside a procedure

My issue is when I try to execute a simple procedure that runs a SQL upload job (sp_start_job)

I get the following error message "ERROR on BindCol"

Can you think of a reason?

[amitrathi239]

Hi,

what will SQL upload job command do in database?

Amit

[shlomi_weiss2]

It runs a system stored procedure sp_start_job that runs a SQL agent job that uploads data to the Data warehouse

[amitrathi239]

Hi,

Not very sure if it will work from webi. reason is webi is a tool for data extraction from data base for reports.but  here you are using  this as trigger some job at database from webi.

Amit

[shlomi_weiss2]

the stored procedure is being run when I run the report, even though I get the error message