Search results for query: *

I have package: CREATE OR REPLACE PACKAGE UPD_FUNCTION_STATUS AS TYPE tJacketID is TABLE of NUMBER(10) INDEX BY BINARY_INTEGER; PROCEDURE UPD_OPEN_WAIT (JacketID IN tJacketID ); END; How can I execute this package from sql*plus? I tryed to set: var JacketID TABLE of NUMBER(10) INDEX BY...

How can I use codabar? Do i need additional functions for that? I have it in fonts and when I format fiels with codabar, all order_id look the same. Please help.Thanks.

I can't figure out why I have this error. I have two picture boxes. One picData as a frame for another picData2 where I load controls in run time. Private Sub picData_Resize() Dim sngHeight As Single ' Initializations sngHeight = 0 scbVert.Visible = (picData2.Height > ScaleHeight)...

I have text box with mltLine=true. The problem is if user put "enter" in this box it triggers the command button click event. How cam I void it? Thanks.

I have small procedure, Private Sub picData_Resize() Dim sngHeight As Single sngHeight = Me.txtName(0).Height * Me.txtName.Count + 100 scbVert.Visible = sngHeight > ScaleHeight .... some code End Sub scbVert is flat scroll bar. It's never getting Visible even when sngHeight >...

I have three input parameters and record selection formula looked like this: {ORDER_PROC_V.ACCOUNT_ID} = {?Account_ID} and {ORDER_PROC_V.SHIP_DATE} >= {?FromDate} and {ORDER_PROC_V.SHIP_DATE} < DateAdd("d", 1, {?ToDate}) It worked fine until I inserted control structure and changed formula on...

I use selection formula from VB. {ORDER_PROC_V.SHIP_DATE} in Date (2004, 8, 5) to Date (2004, 8, 5) . How can I modify this formula if I need report just for one single day:{ORDER_PROC_V.SHIP_DATE}=Date (2004, 8, 5) Thanks.

I need in one SQL count by two different group: by order_id from ORDERS table and item_id from order_items. I have the folloing SQL: SELECT O.ACCOUNT_ID, O.SHIP_DATE, count(O.ORDER_ID) , COUNT(I.ITEM_ID) over (partition by COUNT(O.ORDER_ID) ) LINE_ITEMS FROM orders o, order_items i WHERE...

I have order_id status tr_number 123 null 99991 123 null 99992 123 V 99993 128 null 99994 128 V 99995 130 null 99996 130 null 99997 And I need to select orders which have at least one status "V" , and how many such...

When I connect to Database I see just PUBLIC and SYS users. What settings I have to change? Thanks.

We have two databases, dev and prod. I created publik link on dev, COM_PROD. Still when i use desc myTable@COM_PROD, it gives description of myTable on development server. What could be wrong? Thanks.

In table we have order_id (number) and ship_status (varchar2(1)). I'm trying to create Unique as order_id and status. If status null the same order_id can be in table a few times, but if status 'V' it should be unique. Can I do that thru oracle. Thanks.

We have two servers: development and production. I run this sql: select DATE_LAST_USED from inventory where item_code='125-325' and DATE_LAST_USED <=TO_DATE('07081997','mmddyyyy') ; on development i have: no row selected, and on production I have: DATE_LAST --------- 02-AUG-04 What could...

I have table jacket_function with fields: (object_id - number Primary key generated by trigger, Jacket_object_id Foreign Key refers to the field object_id of Jacket table also generated by trigger ) I run into the situation when I have to save data in jacket_function first and then jacket...

I need to create a new user (newUser)and give him all privilege which have another user, let's say, oldUser. For ex. oldUser is an owner tables T1,T2,T3; oldUser have priviledges on select tables oe.T5,inv.T6. I want that newUser would have select privileges on all these tables. Can I do it in...

How can I use the DifinedSize Property of Recordset ADO Object for numeric fields. For ex. I have in oracle table field size number(3), I want to prevent a user type in more than 3 digits. Anywhere, after procedure: txtFiels.MaxLength=objRS("CODE").DefinedSize still can type 10 digits. Thanks.

I connected as system and use: rename TABLE SUPPORTFILES.BILLIBG_TERMS to SUPPORTFILES.BILLING_TERMS; Have error: ORA-00903: invalid table name

I use OraParameter object supporting PL/SQL cursor. When I create ora parameter if there is way to know in advance that parameter exists. I code: MyDatabase.Parameters.Add "NAME", "JOCKSPORTS", ORAPARM_INPUT MyDatabase.Parameters("NAME").ServerType = ORATYPE_VARCHAR2 some code ...

I can call any control on form as Me.ctl. How can I find out the same thing about frame. I have Frames as control array (Me.Frame(i)) On every frame I have txtlabelName as control array. Let's say every frame(0) has 4 elements of txtlabelName indexing from 0 to 3, frame(1) has 4 elements of...

We are using VB as Front-end and Oracle DB as back-end. I know there is a suggestion to use the oracle procedures for modifying data. But it's so simple to use ADO and work with data thru VB objects. What is the best way and why? thanks.