A query for a stored procedure for multiple delete yield an error message shown way below. CREATE OR REPLACE PROCEDURE delete_dim_page(_page_id bigint) LANGUAG
I'm trying to create a stored procedure that backs up a database, however whenever I execute it, the folder I'm trying to backup to remains empty. Here is my st
In a Postgres 12 database, I have multiple queries (SELECT, UPDATE, ...) in a function that all together take about 20 minutes to complete. I have a check at th
I have this stored procedure that selects the top 10 results from its inner join CREATE PROCEDURE SP_SELECT_DOCS_WHERE_JOBID_STATUS @JobID INT, @BatchID
As title, I'm writing some Stored Procedure on Oracle, first I checked the version SELECT * FROM v$version; with result Oracle Database 11g Enterprise Editi
Trying to execute a procedure in perl script, Proceure ->create or replace PROCEDURE Getproc ( v_catg IN CHAR DEFAULT NULL, v_cursor OUT SYS_REFCURS
I want to force a user's string input in a stored procedure to uppercase. I tried writing UPPER prior to the @parameterName but I got a syntax error. Is this
I want to force a user's string input in a stored procedure to uppercase. I tried writing UPPER prior to the @parameterName but I got a syntax error. Is this
I have created a destination data table (exp: tbl_des_txn) with the same structure as the source data table (exp: tbl_source_txn). including columns: txn_id, tx
I am doing POC on Snowflake and exploring this product. I have a question: in SQL Server, we have 400-500 stored procedures and these stored procedures are get
My goal is to create a stored procedure that generates new GUIDs using NEWSEQUENTIALID that can then be used when inserting data into a different table in the s
So i have a query that i would like to execute through a stored procedure and export the output of the query to a CSV file. But only the last column name is not
Hi I am trying to call an as400 stored procedure using OleDB. Could you please post an example of how to do it cause I've been following some tutorials but not
TABLE: Column name Data type Constraints DEPARTMENT_ID NUMBER(5) PK DEPARTMENT_NAME VARCHAR2(25) NOT NULL LOCATION_ID VARCHAR2(15) I have tried this. But stil
This script works fine when running on dbeaver, I can work with the new created temp table: SELECT someField INTO TEMP tmp_TableZZ FROM "_fdw
I am trying to partition the data from a Snowflake table and storing it as a parquet file in a S3 bucket. This partition allows me to store the data organised b
I'm using Entity Framework to call a stored procedure which takes 2 minutes to execute. As a result, I get a timeout exception. Is there any way I can use my
I am trying to test an Oracle Stored Procedure in JMeter. I have already done the configuration to the DB successfully, but when I call the stored procedure and
I wrote a stored procedure in SQL Server that gets passed 4 parameters. I want to check the first parameter @table_name to make sure it uses only whitelist char
I've looked up questions here as well as looking online and watching videos but I'm still confused exactly what IN, OUT is. The reason I'm asking is because I'm