MySQL Forums
Forum List  »  Newbie

Pass a Parameter
Posted by: James Whitmore
Date: March 31, 2022 08:17AM

Hi All I am new to MYSQL I have always worked and written in SQL. I have a client that wants to move data from a 3rd party Oracle DB to an on Prem SQL DB but it needs to be dynamic. I am using SSIS to pull the data across and what I am doing is creating a SQL table of all DB Table names 5000+ and Iwant to pass through a parameter into MY SQL Code, Currently it reads (Select * FROM MyTable) and what I want to have is (Select * FROM @Mytable) or (EXEC(@Mytable)) either is an option.

Options: ReplyQuote


Subject
Written By
Posted
Pass a Parameter
March 31, 2022 08:17AM
March 31, 2022 10:00AM
April 04, 2022 07:16AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.