When an ALTER TABLE command adding a column with default value is executed, an UPDATE command will populate the new column with the default value, right? So, if there´s an "on" update trigger on this table, will this trigger be executed too?
Hi,
I'm newbie on Unix, and I need to create a script renaming some files. The loop using the "for" command works fine unless there isn't a file to rename. For example:
FLD="/test/fl*"
for FL in $FLD
do
mv $FL /test/file.txt
#other statements....
done
So, if there's no file in the...
Hi, I just started using Delphi and I need to use a third part component, I already got the component source code. I can compile, install and place the package components on a form, but when I run the application this error is returned:
[Error] File not found: 'xxxxx.R32'
the error refers to...
Hi,
I created a dynamic library for use as an external procedure, but the extproc returns the error:
ORA-28595 - Invalid DLL path.
I already checked the library path but it's right and the oracle user owns the directory and the library, has all the permitions needed by the OS.
any sugestions?
Hi,
I'm trying to use a OracleOCIConnection in a Java Stored Procedure, but the JVM seems to be 1.3, so it doesn't support this object, how can I update the JVM to 1.4 or just load the necessary classes? I tried to load the ojdbc14.jar to the system's schema but the user needs a...
Hi,
I need to read data from a file, so I create a Java Stored Procedure, but when I call the procedure this error is returned:
ORA-29532: Java call terminated by uncaught Java exception: java.security.AccessControlException: the Permission (java.io.FilePermission /PublicFiles/tete.dxf read)...
Hi,
I'm using an Oracle example to create an stored procedure to count how many rows there are in a table, the procedure works, but only to the user who owns the class, if another user calls the procedure the error ORA-00942 is returned, even if the user has execute grant to the Java class.
Can...
Hi guys, I'm not an ASP programmer, but I use OLEDB in my VB projects and the OLEDB recordset has has some tricks, you can't access the RecordCount property unless you move to the last record, but this cause an error if the Recorset is empty, so I use this:
if not ( RS.EOF and RS.BOF) then...
Hi!
I'm trying to access an object reference in a view in another schema, (connecting using a user that has just the connect attribute), this view is a union of two collections, it has the name and a reference to the address of the vendor and manufacturer, so I use the following code:
dim...
Hi,
I want to list diferente kind of files in a directory, for example *.txt,*.zip,... But I want to know if I can do it just once, instead of call the DIR function for each extension
I tried to create the value but I always get a "permission denied" message, should a create the value before send to the printer or after? Because after I send something to the printer it prompts the dialog box.
I also tried to use the distiller printer but it creates a value under the...
I couldn't find neither the pdfwrit.ini or _pdf.ini files, in fact I didn't find any *pdf*.ini. I've read somewhere that we should set a registry value with the output file name, does anybody know the key path?
If you are using VB, references de "Acrobat Type Lybrary" in you project, then add an CAcroApp object, this is the Acrobat application class. Use this Object do open the two files to be merged, in the first document use the method "InsertPages" to add the second file. Now...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.