Questions tagged [execute]

In many dialects of SQL, the execute statement is used to invoke a stored procedure.

In many dialects of SQL, the execute or exec statement is used to invoke a stored procedure.

For example:

CREATE PROCEDURE MyStoredProc @myParam NVARCHAR(500)
AS
BEGIN
    ...
END
GO

EXEC MyStoredProc @myParam = N'Testing'

Related Topics

1326 questions
3
votes
1 answer

dBEAVER 7.3.3 how to execute oracle stored procedure

please can you help me to run/execute oracle procedure in dBEAVER? Here is the block where you can see input parameters enter image description here
Andrej Mišuta
  • 31
  • 1
  • 1
  • 3
3
votes
1 answer

Why does my PDO statement -> execute return false?

After near endless rounds of testing different aspects of this, I've determined that the PDO connection works (I can run a simple query and display results), I've determined that the statement is successfully preparing, and that the values are…
somewhatsapient
  • 390
  • 2
  • 3
  • 10
3
votes
1 answer

Google sheets: Class google.script.run not working

My problem is simple. All the possible solutions I searched for online did not address my question. Google's developer website for Class google.script.run (https://developers.google.com/apps-script/guides/html/reference/run#withSuccessHandler)…
3
votes
2 answers

pyodbc execute variable becomes @P1

Hi I'm doing something like: # pyodbc extension cursor.execute("select a from tbl where b=? and c=?", x, y) -- some values in the query in provided by variables. But sometimes the variable is interpreted as @P1 in the query. For example: import…
YJZ
  • 3,934
  • 11
  • 43
  • 67
3
votes
4 answers

Does BigQuery support "execute immediate" command to run dynamic query?

I can code like this in Oracle to create tables dynamically using "execute immediate 'sql query..'" command. create or replace function make_a_table1(p_table_name varchar2, p_column_name varchar2, p_data_type varchar2) return varchar2 is …
Madhu Alle
  • 49
  • 1
  • 1
  • 4
3
votes
4 answers

Window form execute a batch file

I am new to C# programming. I would like to have an application contains 1 text box and 1 submit button to exec a batch file. The file is d:\XMLupdate.bat, but the program appends a number on the command line to the file for example…
QLiu
  • 271
  • 2
  • 8
  • 23
3
votes
1 answer

ELF file - get function of where a string is used

I have an elf file, and I would like to know if it's possible to get some infos about, where an variable (string) is used in the executable. If I print out the strings of the .elf I find an interesting string, and I would like to know, in which…
Manuel
  • 613
  • 1
  • 6
  • 20
3
votes
1 answer

Export pyCharm project for production

I'm quite new on this Python world (i worked in the past with java, c++... but I never used Python). Well, let's go with the question. As I know, when I needed to export a java project, I just needed to create a .war (automaticly if I used…
Tester2000
  • 31
  • 1
  • 1
  • 2
3
votes
2 answers

How to execute a query string in MonetDB

I'm attempting to declare a query string to execute in MonetDB. The documentation is not clear if this is possible, but other engines allow this functionality (such as MySQL and MS SQL Sever). Trying the following execute 'select * from…
3
votes
1 answer

Laravel Run function from console command

LARAVEL 5.2, just created the command named "HelloWorld" and here is the code:
Miril Terolli
  • 211
  • 1
  • 5
  • 14
3
votes
4 answers

Run a jar file from powershell

I want to run a jar file from powershell. Till now I have been able to find this: Start-Process -FilePath java -ArgumentList '-jar Upload_Download.jar FilePickupPath= $pickuppath FileDownloadPath= $download' -PassThru -RedirectStandardError…
Akki
  • 161
  • 1
  • 2
  • 10
3
votes
2 answers

Flask mySQLDB execute success or failure

I am new to Python-Flask and am trying to use MySQLDB to conenct to the database. However, I am unable to determine how to check if the query executed by the cursor is successful or if it failed. In the code below, can someone please advise how I…
tirupats
  • 158
  • 1
  • 10
3
votes
1 answer

Disable the error message (failed to execute script) obtained with pyinstaller

Hi how do I disable the error (failed to execute script) when i run a exe process created with pyintaller ? without fix the script , because the script works well
M Smith
  • 73
  • 7
3
votes
2 answers

How can i call a PHP script from Java code?

As the title says ... I have tried to use the following code to execute a PHP script when user clicks a button in my Java Swing application : URL url = new URL( "http://www.mywebsite.com/my_script.php" ); HttpURLConnection conn = (HttpURLConnection)…
Brad
  • 4,457
  • 10
  • 56
  • 93
3
votes
1 answer

Node.JS load a html page, fill in the form, and press the submit button

I am relatively new to node.js and I am looking at hacking some of my company's products together. However one of the systems is written for Node.js and the other system, that I don't have access too, is controlled by a standard login page. This…
Eric V
  • 249
  • 5
  • 18