Search results for query: *

I am usind read_image_file to display JPG files from my file system in an image item in my form, but for files as large as 800 KB, I get an "FRM-47100: Cannot read image file.". It works fine for 500 KB or smaller JPG files. Is there a size limit for read_image_file? How do I work...

Enrique, It does seem to work fine. Thanks a lot for you help. Carol.

Yes, that solution is similar to the one I used. It's performance is not very satisfactory...

I have a data block in a form. The record where the cursor is located is changed by a stored procedure called through a button. I want the user to see the changes without re-querying. In other words I want to refresh the current record, not the entire block. Is that clearer?

Is there a way to show changes in records in a data block in forms, without using execute_query? I want to refresh only the select record. Is there a way to do that? Thanks in advance for help. Carol.

I am trying to edit a word document replacing bookmarks. The following code is opening the document, wich is an embedded databease item OLE, but the gotos and inserts are not working. In my tests with an independently executing word application, the inserts work, but the gotos to the bookmarks...

I thought session parameters where client-side. My CHARSET is US7ASCII in database parameters as follows: SQL> select * from nls_database_parameters; PARAMETER VALUE ------------------------------ ---------------------------------------- NLS_LANGUAGE...

I need to turn data entered by user in a form to upper case, but accents are displayed incorrectly if I set item property "case restriction" to upper. The same happen if I run the following in Sql Plus: SQL> select upper('Informações') from dual; UPPER('INFO ----------- INFORMAGUES...

I have a form with several buttons. They are identical, only changing the icon filename, but some icons won't be centered in their buttons and are displayed in the lower right bottom of the button. There is no button property related to icon position. Is there a way to workaround this? Thakns...

How can I populate the list of values of a parameter in reports, using the value entered in a previous parameter? I have a list of companies, and when the user choses one, I want the list of departments to be the ones of the chosen company. Can I do that? Thanks in advance for help.

How do I workaround the limit of 2000 characteres imposed by graphics?

I am trying to use a chart item in my form, but I am getting compilation erros using og.refresh, og.close or any other built-in from OG package. Can't I use this package in Forms6i?

How do I turn Forms6i items properties back to <Unspecified>? I want the foreground and background colors of my canvases and LOV's to be the same as the Windows default, but forms does not allow me to leave the property blank, after I changed it. I don't want to redo all my forms.

I need the information to be visible to other forms...

Is there any simple way to workaround the size limit of global variables in forms? I have an information that may be larger than 255 characters, but I do not wish to break it in small parts, specially because this information size may vary a lot. thanks in advance for help. Carol.

Yes, that's it. I replaced all the 'chr(13)' by 'chr(10)' and it worked fine. Thank you very much for your help.

I am sorry but you are wrong. The body I provided is from user_triggers view. I'm sorry you can't come here to see it for yourself. Thank you for your help anyway.

trigger_body: DECLARE v_num_evento AUD_EVENTOS.num_evento_AUD%TYPE; v_login_db V$SESSION.SCHEMANAME%TYPE; v_osuser V$SESSION.OSUSER%TYPE; v_maquina V$SESSION.MACHINE%TYPE; v_programa V$SESSION.PROGRAM%TYPE; BEGIN -- busca a sequencia SELECT...

It is a procedure I created as a test to find out what was wrong. The same problem that happened with the trigger happened with that procedure with nothing in it to be the cause of the error. Got it?

Below is the test procedure as it appears in PLEdit: procedure AUD_001_U is BEGIN null; END; As you can see there's none of the errors you said, but thanks for your help anyway.