Recent content by aljubicic

Hi, Just wondering if anyone would know why the below problem would be occuring?? We have a table which holds a BLOB column which we use to store word documents. Now there is a stored proc which reads this blob using DBMS_LOB.READ (rec_letter.letter_file, l_amount, l_pos, l_buffer); where...

Hi All, I have an application which I help build and created a msi file for installtion purposes. Installing the application registers a few dlls in the GAC. Now when I want to change something in the application from .NET I am changing of of these components dlls that is in the GAC. Now to...

Hi, Just need to know how to do a SQL select on say the data, node etc field from the SWLOCALMSG object which is used as a type for an advanced Queue. CREATE OR REPLACE TYPE SWLOCALMSG AS OBJECT ( msginfo VARCHAR2(500), node VARCHAR2(24), contenttype...

Hi, I have two tables (TabA & TabB) with a foreign key on TabB referencing a PK on TabA. Therefore there is a one to many relationship between the two tables. For the query below how which may produce a number of records from TabB , how can i limit it to just giving me the last record in the...

Hi, How would I write an update to increment the date field for a dataset by one day the column is a timestamp like '12-Sep-2006 12:34:00' I just want to increment the date part by a day and leave the time component as is. eg. update [table_name] set [column_name] = ....... Any examples...

Hi, How do I get two RichTextBox's to scroll vertically together? So when you scroll down one richtextbox it automatically scrolls the other as well. Examples would be helpful. Thanks Anthony

Hi, I am developing an application that will need to display the script for such objects as stored procs, triggers, schemas, seqeunces etc. How can I extract the script for a table or stored proc say that will show all in the script including indexes, constraints, grants etc. I would like it...

Hi, I want to be able to uppercase all Varchar2 fields on an Insert or Update Trigger. Currently I actually specify the the columns but can this be done generically across allthe fields without specifying the column names. CREATE OR REPLACE TRIGGER TOWER.INGPTST_TBIU_MOD BEFORE INSERT OR...

Hi, I want to be able to run SQLPlus's COPY command from within a PL/SQL block of code. Is this possible and how would I go about doing this?? Any examples would help greatly.. DECLARE {Variable Declarations} BEGIN {Code.....} {Be able to RUN COPY command} {Code} END; /

Hi, I am cuurently setting up an environment at home to mimic the setup at work, which is comprised of an application connected to a SQL Server. Now this SQL Server has linked Servers setup to other servers for Data transactions using triggers. Since I have only one SQL Server setup at home I...

Thanks for the help, will try it

Hi All, How do launch a word document. I need to launch a word document with prepopulated text. I want to be able to specify the the font and font size used when launching the Word Document. Any help or examples of code would be great Thanks Anthony

Yes I have downloaded the font 3 of 9, but how do I launch a word document already populated with barcoded text?

Hi All, I need some help printing Barcodes in word. I have a VB.Net application that does a few things but what I need it also to do is for a user to be able to enter text information into 5 text fields of the app and for it to launch Microsoft word using Code 3 of 9 font to display the 5...

Excuse me sem but I didn't quite understand you first comment. So how would I relate it to my example??