Search results for query: *

I receive the following error after attempting to run the program unit below in a report. REP-1401: 'cf_1' : Fatal PL/SQL error occurred ORA-06502: PL/SQL: numeric or value error FUNCTION CF_1 RETURN CHARACTER IS v_age NUMBER; v_return CHARACTER; BEGIN v_age := TRUNC(SYSDATE) -...

I need to be able to group a set of dates by 30 days away, 60 days away and 90 days away. I'm new to Oracle Reports and I've been researching within the help tools, but have been unsuccesful in finding a solution. Can anyone please shed some light on how to accomplish this? I have included...

I have 2 user parameters: One that allows user to select the office. Here is the code: select DISTINCT e.lastname from t_entity e INNER JOIN t_entityrelationship er on e.entityid = er.childentityid INNER JOIN t_relationshiptype r on er.childrelationshiptypeid = r.relationshiptypeid where...

I want to create a report that displays employees & their corresponding extensions. However, I only know basic ways to manipulate the data appearance. As of right now, the data takes up less than half of the width of the paper. What I would like is for two columns of employees & extensions...

In need a query that would remove carriage returns from a section of a report. I've tried various different ways, this is my latest: select c.casesummary from t_case c replace(c.casesummary,chr(13)||chr(10),' ') I keep getting an ORA-00907 error "missing right parenthesis" ugh - i'm at...