Sitemap

Amicuk Programming Answers

How can we update procedure in Database Directly

2015-10-11   Views:0

Advertisement

Hi Experts how can we create a stored procedure in a database directly. for example I made a crystal report with a demo databse, then I want to run that report on production database. for that I have to create stored procedure manually. I want that W

Hi Experts
how can we create a stored procedure in a database directly. for example I made a crystal report with a demo databse, then I want to run that report on production database. for that I have to create stored procedure manually. I want that When I run the report It automatically create stored procedure . or other simple way to create stored procedure
Regards
Gorge
Edited by: Gorge Ance on May 13, 2009 8:09 AM

The replay answer
Advertisement
Hi
If your field match what you have in demo and production ,all you need to do is run that stored procedure pointing to correct database .So you probable have to change alter to create .
When you go to sql server , you have a choice to run a query of stored procedure  against the particular dtabase while you use query analyser .
In crystal report , you have to manually change the datasource and update store procedure.
Your report will now point to production database and point to correct stored procedure .
Hope this helps
Bishal

Go to See the other 4 answers

How can we update procedure in Database Directly

Category:DefaultRelease time:2015-10-11Views:130

Hi Experts how can we create a stored procedure in a database directly. for example I made a crystal report with a demo databse, then I want to run that report on production database. for that I have to create stored procedure manually. I want that W[More]

Update procedure from APEX 3.1 to 3.1.2 on Oracle XE database

Category:DefaultRelease time:-0001-11-30Views:130

Hello, how to make an update of APEX 3.1 to 3.1.2 on an Oracle XE database with the full installation pack (which you get normally at OTN)? I mean the patchset 7313609 from Metalink wont work on a XE database because it doesn't have the opatch featur[More]

Block with more than one table type agurment -  Update Procedure for Block

Category:DefaultRelease time:2015-10-11Views:130

Hi, I have one form with 3 Block. First Block is single row block, and other 2 are details block . The details balocks are based on the Procedure datasource, because of the complex query conditions. Now my requirement is When Inserting / Updating the[More]

U430 BIOS Update Procedure (fixes wake from sleep issue on Windows 8.1)

Category:DefaultRelease time:2015-10-11Views:130

Hopefully this will make the BIOS update process a bit easier.  The following steps address two common questions (Failed BIOS Update and the Windows message about improperly configured Secure Boot).  NOTE: After a successful BIOS update you will want[More]

Error Stored Procedure Upgrading database from SBO 2007A PL42 to SBO 8.8

Category:DefaultRelease time:2015-10-11Views:130

Hi, When executing the SBO 8.8 PL00  upgrade procedure for databases for an "old" database 2007A PL 42, upgrtade stops whith an error concerning a missing stored procedure "_TmSp_CorrectWrongDocLineNumberInOINMForIPF which is not found"[More]

How Do I Make Updated Procedure in the Program Unit of the Form to Work?

Category:DefaultRelease time:-0001-11-30Views:130

I have updated a procedure in the Program Unit of the Form that I modified. I am not sure what are the proper ways to compile or load the changed procedure in my form to make sure the changes work. Please help me with the following questions: Do I ha[More]

Data is not updated in the database

Category:DefaultRelease time:2015-10-11Views:130

hi.. to all.. i'm using the following code ...... but the data is not updated in the database.. the output window get closed as soon as i clicked save button... i don't know wat's problem with the program... Plz help me.. to get resolve this problem.[More]

How to extract data from oracle database directly in to bi7.0 (net weaver)

Category:DefaultRelease time:2015-10-11Views:130

how to extract data from oracle database directly in to bi7.0 (net weaver)? is it something do with EDI? can anybody explain me in detail? Thanks YorkYou can use UDConnect to get from Oracle database in to BW <b>Data Transfer with UD Connect -</b[More]

Updating values in database table through Transaction

Category:DefaultRelease time:2015-10-11Views:130

Hi, Actually We have one transaction named EWAWA01. In that when we display the values from the transaction, there is a netweight field. The transaction displaying netweight values, but that value is not updated in the database table named EWA_WA_WEI[More]

IPhoto version 9.4.3 update procedure is not responding.

Category:DefaultRelease time:2015-10-11Views:130

Hi, I have a problem concerning a normal software update. I have a MacBook Pro runnig OS X 10.8.3 (12D78). Two days ago i got a normal message telling that there is an update available for a new verson of iPhoto (9.4.3) Everything went as normal to t[More]

Getting result set from stored procedures in database controls in weblogic

Category:DefaultRelease time:2015-10-11Views:130

I am calling a stored procedure from database control which actually returns a result set when i call the stored procedure like * @jc:sql statement="call PROC4()" ResultSet sampleProc() throws SQLException; it gives me exception saying "web[More]

Hot
I have had to restore my ipad to factory settings, having made a backup on my pc first. When Ihave tried to restore from my pc I have no apps!! Please can anyone help me get them back with all their data. I don't have wifi at home and I have never be [More]
Until today, the app opened without a problem. I went to the "store" and now it won't reopen.Delete the app and then redownload.  Cheers, TomRead other 2 answers [More]
Hi all! Is there a limitation of column numbers in the APEX 4.1 data loading page? My DB Object has 59 columns and they are all available for example in the unique colum drop boxes of my data load table definition. On page two of the wizard created d [More]
Hi, I am doing a payment in A/R Invoice (133). Could you give me a code sample of payment with cash, bank transfer, Credit Card, OR Check? (C# or VB) Thank you, RuneHi, Please find the payment code below for check, cash, credit card, and bank transfe [More]
hello all, i have a requirement where i have two tables in a tray on one condition  i have to invisible the second table. can one suggest is it possible, if yes how? what i have done is in a tray i put 2 tables and the buttons.Is it the right way ?? [More]
In the HTML of a web page how can I determine or be notified that an applet is loaded and initialized similar to "onload=foo()" on the <body> statement. At least in NS 7+ the <body> onload executes before the applets contained in the [More]
My contacts in my Address Book are sorted as "LAST NAME, FIRST NAME, MIDDLE NAME." But after syncing my contact with my iPhone, the contact listed on the iPhone are listed as "LAST NAME, MIDDLE NAME, FIRST NAME." How can I make sure th [More]
I have a MacBook Pro with OS X 10.7.5 on it.  When I'm connected to WIFI I sometimes lose control over my trackpad, even though I may not be surfing the web on safari. Is there a virus on my computer or is there something wrong with my track pad. Ive [More]
 Here is a way to solve your problem. try to use Runtime.getRuntime().load(absolute_library_path); However, make a copy of the library you tried to load and name it uniquely such as append the current miliseconds. After completed loading the library [More]
Hi Friends, I want to update my database table with new record for this I wrote a coding like this, but i am unable to update the database table please find my coding: LOOP AT lt_invmov INTO lw_invmov WHERE check = 'X'.           SELECT  MAX( trans ) [More]