Questions tagged [ora-01756]
2 questions
2
votes
1 answer
Insert Into Statement causes ORA-01756: quoted string not properly terminated
Environment:
DevArt Drivers for Oracle
.NET 4.5
I'm trying to execute the following statement:
INSERT INTO T_CUSTOMERS_T
("ID", "NAME1", "NAME2", "NAME", "STREET",
"POSTAL", "CITY", "COUNTRY", "TEL",…
SeeSharp
- 21
- 3
0
votes
1 answer
Searching data from a table using stored procedure in oracle by passing tablename as a parameter
This procedure is not working properly.
create or replace procedure bank_search_sp
(
p_tablename in varchar2,
p_searchname in varchar2,
p_bankcode out varchar2,
p_bankname out varchar2,
p_dist_code out number
)
as
v_tem varchar2(5000);
begin
v_tem…
Remya
- 21
- 3