Re: Query using new schema but prepared statement using old schema
Posted by:
No No
Date: October 27, 2020 01:20AM
This recreates the behavior (tips on formatting appreciated):
create schema test1;
create schema test2;
create table test1.preptest
(
id int primary key,
data varchar(255)
);
create table test2.preptest
(
id int primary key,
data varchar(255)
);
use test1;
select database();
prepare preptest_insert from
'insert into preptest (id, data) values (?, ?)';
set @id = 1;
set @data = 'something';
execute preptest_insert using @id, @data;
use test2;
select database();
execute preptest_insert using @id, @data;
Subject
Written By
Posted
Re: Query using new schema but prepared statement using old schema
October 27, 2020 01:20AM
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.