SQL Stored Procedure (v2)

(0) Share

Report

Posted on by RemyO

When using SQL Stored Procedure (v2) Is it possible to fill out the databasename using a variable ?

I keep getting

"message": "The request entity's media type 'text/plain' is not supported for this resource."

Categories:

Using connectors

I have the same question (0)

All responses (7)

Answers (0)

Pstork1 68,678 Most Valuable Professional on at

Like (0)

Report

Re: SQL Stored Procedure (v2)

Are you just typing the name in the blank, or are you using Enter Custom Value from the dropdown. You should be able to do it if you use the dropdown.

Was this reply helpful? Yes No
RemyO 17 on at

Like (0)

Report

Re: SQL Stored Procedure (v2)

That is what i did. I initialized a variable contaning the database name.
Then used: Enter custom value in which i supplied the variable.
Then added the 1 parameteri have (also by using a variable)

Then i got the error: "message": "The request entity's media type 'text/plain' is not supported for this resource."

Was this reply helpful? Yes No
Pstork1 68,678 Most Valuable Professional on at

Like (0)

Report

Re: SQL Stored Procedure (v2)

What is the data type of the SQL parameter? Does it work if you pick the database name from the dropdown without using a variable?

Was this reply helpful? Yes No
RemyO 17 on at

Like (0)

Report

Re: SQL Stored Procedure (v2)

- Datatype is string
- If I use the dataname from connection it works.

(I would like a variable since i have to connect to different databases)

Was this reply helpful? Yes No
Pstork1 68,678 Most Valuable Professional on at

Like (0)

Report

Re: SQL Stored Procedure (v2)

I think the problem is that the stored procedure itself is different for each database. Yes it can have the same name and the same definition, but in the SQL master table its a different object. So if you use a custom string to connect to the database it can't pre-load the stored procedure schema. I thought it might still work, but evidently it won't.

Was this reply helpful? Yes No
RemyO 17 on at

Like (0)

Report

Re: SQL Stored Procedure (v2)

It doesnt even work for a single one.
Say my database is called test.

If i select that database from the dropdown it works
If i select that database using a variable it doesnt work.
Why give me the option to use a custom variable if the functionality doesnt work ?

Was this reply helpful? Yes No
Pstork1 68,678 Most Valuable Professional on at

Like (0)

Report

Re: SQL Stored Procedure (v2)

Just because all those dropdowns give you that option. For some things it works for others it doesn't.

Was this reply helpful? Yes No