Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by Shobin

  1. Shobin

    frm-30162 error?

    Hi,<br> <br> Let me guess you're using forms 5.0... i've also had that error at the beginning then i've installed a patch for developper 2.1 and that message didn't appear anymore.<br> <br> Good Luck<br> <br> Shobin<br>
  2. Shobin

    I'm using reports2.5 under O 7.3 When you run a report you get a scre

    Hello Tek1234,<br> <br> I'm also using reports2.5 under O7.3 for a while and i don't any way of bypassing that screen... i hope i'm mistaken.<br> <br> Shobin
  3. Shobin

    query on date field

    Hi Bookor,<br> <br> You should try TRUNC, TRUNC(date,'DD'); <br> <br> Good Luck<br> <br> Shobin
  4. Shobin

    Can you re-query a query ?

    If you use the Keyword DISTINCT on your select and don't put the field FullName, you'll have the ProjectID of both SomeNames.<br> <br> About requerying i don't know anything about it...<br> <br> Good Luck
  5. Shobin

    Custom sort in SQL?

    This suggestion it only works for one book at the time, but you can create a cursor to calculate the Position, and then instead of doing the Select substr... create view as Select substr...<br> <br> Declare <br> Position number(2);<br> <br> Begin<br> Select instr(title,' ') <br> into...
  6. Shobin

    Run a query # of times in a given month?

    Hi,<br> <br> I don't know if you expect only one field as result of your query, see if this helps you:<br> <br> Select count(*),ddate<br> from sorted<br> where to_char(ddate,'MMYYYY') = to_char(sysdate,'MMYYYY')<br> group by ddate;<br> <br> this returns something like this:<br> <br> COUNT(*)...
  7. Shobin

    Make query run # of times in the month??

    Hi,<br> <br> I don't know if you expect only one field as result of your query, see if this helps you:<br> <br> Select count(*),ddate<br> from sorted<br> where to_char(ddate,'MMYYYY') = to_char(sysdate,'MMYYYY')<br> group by ddate;<br> <br> this returns something like this:<br> <br> COUNT(*)...
  8. Shobin

    reports 2.5 performance

    If you add the system parameter MODE to your default parameter form, with the value CHARACTER, you'll have a ascii report. Be careful because some fields of the layout must be bigger or it'll appear **** on the field.
  9. Shobin

    How to get a query to output to a .dbf file???

    If you use the query on the Oracle Browser you can save the result into a csv file, select the export option and the type of file you which.
  10. Shobin

    Page break when detail reaches a certain number

    On Report 2.5 you have a boilerplate property called Minimum Widow Lines, if you put de minimum lines = 3 an page break occurs..<br> <br>
  11. Shobin

    reports 2.5 performance

    The only way i'm remembering to speed up your reports is convert them to ascii, instead of bipmap. But you can only do this if you have the source code, that i suppose you don't like you said in another post.<br> <br> Good Luck<br> <br>
  12. Shobin

    multiple ver of developer runtimes

    The best option is to convert the forms 4.5 and reports 2.5, it's very simple you only need to compile them using the forms builder (5.0) and report builder (3.0).
  13. Shobin

    Where are Oracle Apps library files located?

    I don´t know your application of Purchasing, but the pll's are usually on the directory of orant\forms45\plsqlib, orant\graphics\rob\pll, etc...
  14. Shobin

    Creating DBA Login.

    You don't need to create a dba login, you have two dba users:<br> sys,system<br> <br> They are automatically created and have the dba role. The password from sys is change_on_install , system is manager.<br>
  15. Shobin

    Calling a C program from PL/SQL

    You can use winrsh to call your C program.
See more

Part and Inventory Search

Back
Top