Hello,
I have a base oracle and when I make a select of a specific field the information that returns has accentuation, ex: "RECEPTION"
But when I save this information in a text file using the UTL_FILE.PUT_LINE (FIELD) the information in the...
I have a function that will get a generic sql to do an operation on the database, after sending the command, I have in the log is information "ThreadAbortException", does anyone know how to work around this problem?
public static bool ExecutaC...
I need to pass an Oracle database to Access. However, my Access is 97, and only contains 999000 rows. My Oracle database has 12000000 lines
How do I export Oracle to multiple Access files?
I have an attribute that takes a string and must be persisted in a clob in the oracle sql. I looked in the documentation that should be used annotation @Lob:
@Lob indicates that the property should be persisted in a Blob or a
Clob, depen...
I have a record of
TYPE trec IS RECORD (
cd_multi_empresa NUMBER(8,2),
tp_atendimento CHAR(2)
);
vcAtendimento trec;
I need a registry vector, I used this and command:
TYPE TcAtendimento IS VARRAY(10) OF vcAt...
I'm using a record to store data:
TYPE TvcAtendimento IS RECORD(
CD_ESPECIALIDADE DsSch.especialid.cd_especialid%type,
CD_MULTI_EMPRESA DsSch.multi_empresas.cd_multi_empresa%type,
TP_ATENDIMENTO DsSch.atendime.tp_atend...
I'm having a hard time creating a login form using Oracle BD in MySQL and PostgreSQL works perfectly, I'm trying to use oci_num_rows <=0 , however the variable returns error, saying that Oracle waits 1, I can not understand, so If someo...
I have two problems setting up the oracle connection.
A PHP Error was encountered
Severity: Notice
Message: Use of undefined constant OCI_COMMIT_ON_SUCCESS - assumed 'OCI_COMMIT_ON_SUCCESS'
Filename: database/DB.php
Line Number: 201
Backtr...
Good afternoon,
I'm using the PL / SQL developer tool, and in debugging I want to check the contents of a collection in oracle.
I saw that you have an option (when right-clicking) "View Collection variable", but I was not successful, becau...