apex

Salesforce.com - Why uploading of Apex class is not working?

I have an Apex class (controller) originally developed under Developer Edition and need to upload it to production which is Enterprise Edition. The upload fails with following message classes/RenewalController.cls(RenewalController):An error occurred on your page. package.xml(RenewalController):An object 'RenewalController' of type Ap...

What is the default URL for APEX for an Oracle XE installation?

I've installed Oracle XE with APEX, but forgot to write down the URL to access it. How may I determine the URL? ...

Force.com IDE - Eclipse Plugin doesn't work?

Hi, I'm new to Apex and have just downloaded Eclipse to get to work Eclipse SDK 3.3.2 I've followed the instructions on http://wiki.apexdevnet.com/index.php/Force.com_IDE_Installation_for_Eclipse_3.3.x and have added the Remote site: http://www.adnsandbox.com/tools/ide/install/ but i get a dialog telling me "No features found on ...

Customising a Custom Objects panel on an Account details page (Salesforce)

I've created a custom object, I have it appearing automatically on the Account details page (think Quote example). But the quote only has a name column, how do I get it to show other fields? much like the opportunities panel on the account panel. Thanks ...

SELECT * breaks when adding columns in Oracle Application Express (ApEx) 3.0

When I define a report region's SQL as SELECT * FROM some_table, all is fine until new columns are added to some_table -- then it breaks with a "ORAxxx No data found" error. It is easy to remediate, as it's enough to Apply Changes on the region again, even without making any changes. However, it does not make for a robust application. ...

Alternatives to Oracle application express?

I've using Oracle Application Express (apex) which is the most fast database application builder for the web that I've seen. Oracle Apex is like Microsoft Access for desktop and Oracle databases. Any one knows about alternatives? EDIT: For alternative I mean "There is any tool comparing this one?". Of course there are a lot of frame...

Salesforce - How to Deploy between Environments (Sandboxes, Live etc)

We're looking into setting up a proper deployment process. From what I've read there seems to be 4 methods of doing this. Copy & Paste -- We don't want to do this Using the "Package" mechanism built into the Salesforce Web Interface Eclipse Force IDE "Deploy to Server" option Ant Script (haven't tried this one yet) Does anyone have ...

Oracle: Pattern for to_char(number) to add additional ascii characters?

Using the Oracle to_char(number) function, is it possible to append ascii characters to the returned string? Specifically, I need to add a percentage character to the returned string. "select to_char(89.2244, '999G999G999G999G990D00') from dual" --> returns "89.22". I need a format pattern that returns "89.22%". I am using this throug...

How can I open a file using java stored procedure

Hello all, I am using oracle database 10g. I have to write a java stroed procedure through which i can call a file at the server and store it locally at the users machine. Im using oracle Apex 3.1.1. ...

How to automatically export an Oracle Applications web form to PDF?

The idea is, upon data entry, automatically export an Oracle Applications (web) form to PDF, storing it in the database. Using XML Publisher, one can allow the user to export it on-demand, but I need to have the report/form PDF generated automatically. Answer A good solution is pretty much covered here. Basically, with a bit of OAF co...

Oracle Multiple Schemas Aggregate Real Time View

All, Looking for some guidance on an Oracle design decision I am currently trying to evaluate: The problem I have data in three separate schemas on the same oracle db server. I am looking to build an application that will show data from all three schemas, however the data that is shown will be based on real time sorting and prioritis...

Add a new file location to the SalesForce File Selector Drop-down

I have written an apex class that will create a PDF quote and attach it to an opportunity. I'm trying to figure out how I can access those attachments when I go to send an email from within SalesForce and then click on Attach File. I want to figure out how to see another location in the drop-down show in the image above that has the ...

ID is not being Passed to Custom Controller from Email Template in SalesForce

I have created a component that is using a custom class. I added this component to an email template. When I try and load the template this is the error message I receive. List has no rows for assignment to SObject. From what I can tell the attribute I have created is not passing the value to my class. Also, when I first pull up the t...

How do you add an edit button to each row in a report in Oracle APEX?

I'm using Oracle APEX and I have a report region in a page that displays columns from a SQL query. I want to add edit buttons to the first column of this report so that the user can click on it and edit/review one of the results. How do I add this edit button? Thanks. ...

How do you add textboxes to Oracle APEX reports?

I'm generating a matrix report in Oracle APEX. I've got the values displaying properly, but when I click the "Edit button", I want all the cells to turn into textboxes. I know that you can do this by changing some settings in the Report Attributes, but the problem is my matrix report is dynamic, which means that I do not know in advance...

Can you add values to an Oracle APEX Shuttle item using a textbox?

The LHS is still dynamically populated with a query, but if it doesn't have a value that you want, then you can just type in a value in the textbox and then add that to the RHS of the shuttle (and update the corresponding tables in the database when you submit). It should also be okay to add that to the LHS when you click on the '<' or '...

How do you pre-set values on the right-hand side of a Shuttle Item in Oracle APEX?

I've looked at numerous forums and tutorials, but it doesn't display the values on the right hand side of the shuttle. However, if I look at the Session values, it seems to set the values properly, it just doesn't show it in the Shuttle Item itself. I've done exactly what I found here: http://dgielis.blogspot.com/2008/01/apex-by-exampl...

how to add Save button to each row of the Oracle APEX Report

I have created an APEX report with Edit Link and Drop Down box. Edit Link is used to edit all the fields of the report. But I would like to add a 'save' button next to Edit link so that users can change values in Drop Down and save the record instead of going to next page using Edit link. Please provide an option to achive this ...

Retrieving deleted records from Apex data loader?

Does anyone have any idea how to retrieve deleted records data from Apex data loader or otherwise from Salesforce except from the Web service? ...

Running an SQL Script with Oracle Application Express

Greetings, I am trying to run an SQL Script uploaded using Application Express (APEX), the web based interface for Oracle DBMS. However, upon clicking the Run button, it does nothing, suspecting any javascript error, I pulled out firebug and there appears to be an error on the js. this.endLine.isPreceding is not a function http://loca...