Recent content by Worad

Thank you Marco Kalter! I know about this "workaround": But I don't mention to it because when I tryed to solve this problem I omit $TIME variable and the code works properly. But in this case the creation time is not known that does not meet the requirements. Separating [Created] into 2 fields...

Hi! This template code [$TEXT CREATED=$DATE $TIME] /** Purpose : [Purpose] Author : [First name] [Last name], [e-mail] Created : [Created=$CREATED] **/ does not work properly. The result is: /** Purpose : purpose Author : fname lname, email Created : 38:43 **/ The variable...

Thank you.

May be the following example help you... In Oracle: --Is Number in set? create or replace type TNumbers as table of number(9); / create or replace function Value_In(p_Value in number, p_Set in TNumbers) return number is v_Result number(1) := 0; begin begin select 1 into v_Result from...

May be the size is 0 for the same reason given in the topic "Passing object with object attributes to database by stored procedure". May be it is impossible now to return data from object atrribute of any object from cursor or stored procedure or function so as in the example given in the topic...

Thank you. Have you any idea how it can be possible to pass oracle object with object attributes to stored procedure? I use TOracleQuery whith creating any oracle object in PL/SQL block and bind variables of ordinal type (number, datetime and so on) to parameters of object constructor. For...

Good afternoon I have the problem with passing object with object attribute to the database by stored procedure. When object is passed as a parameter to stored procedure, it's simple attitubtes(number, datetime and so on) are passed, but complex attribute - object are not passed. The following...

Hi In Oracle 10g in OCI documentation "Oracle

Hi Is a '' string in your DBComboBox.Items? If it is, see below. May be it helps you. _Sometimes_ an Access Violation (AV) occur when '' string is selected in the VCL.ComboBox or VCL.DBComboBox. I around it by using such frase as 'All records', 'Nothing' or 'Any country' and so on. May be it...

Good evening 1. How do I typecast one instance of TOracleObject to another with other type (ancestor to descendant)? 2. How do I use sys.anydata type with DOA 4.0? 3. I have a problem when I tryed to assign an Oracle Object descendant represented by TOracleObject to ancestor. Problem...

Thank you very much.

I use PL/SQL Developer wich version 6.0.0.840.

Thanks. I know the hexadecimal representation of the reference of the object instance. But I can't insert this representation into the table cell in "SQL Window - Edit data of ..." for appropriate field. But when I try to paste obtained reference representation from the clipboard, nothing happens.

Hi. How do