Search results for query: *

Thanks for your time. I actually created it using OEM. I will do as you advised tomorrow morning.

For a textarea how do I limit the number of characters in the box to 500? For input text I can set to maxlength and limit the entry in the input: <INPUT TYPE=TEXT NAME="myInfo" MAXLENGTH=500> For textarea I assume I need to create a validation or something to fetch the length of the field and...

I created the CLOB datatype (called BigField) in my table but when I try and add text info to the CLOB field it seems to not add anymore than 4000 characters. INSERT INTO TableOne (BigField) VALUES ('dsfadfasdfasdfadsfetaere etc....more than 4000 characters here..');

Thanks, I added the CLOB to my table but it only takes 4000 max characters. How do I add more?

I have a text field that has a data type of varchar2(4000). I would like to change it to hold 10,000 but I dont think it can go that big. Please advise how I can do it?

Trying to load JRE 1.6 on Windows Server and it keeps saying my Windows installer is not working properly. I tried downloaded new one from microsoft and still the installer wont work. Any advise? Thanks

I have this email method that worked about 2 months ago. . Today when I used it, it didnt send any emails and I got no error messages on the web page. Where or how can I find out what the issue is or why its not working? public static void send(String smtpServer, String to, String from, String...

Thanks! I will do that on Monday. I googled "Oracle DBA revoke" and found something like this: To revoke DBA privileges from a user: alter user markd revoke DBA. Revoking DBA priviliges SQL> revoke dba from gsdev; I assume that is all I need to do for revoking DBA privilege on my local...

Thanks, In my previous post example I just posted your exact code but I did use my Schema/password and tnsalias. I can understand the import not working but why did the export say it worked (local database to server database) and I didnt see my local database tables in the server? Maybe I...

Thanks, I tried this in my Windows Command Line: imp buffer=15000000 grants=y feedback=1000 fromuser=TEST touser=TEST file=DHUNT.TEST.dump log=TEST_Imp.log userid=TEST/TEST@tnsalias and it gave me a message imp - 00013 only DBA can import.. I am not a DBA on the Server. I assume I cant import...

I have a local development Oracle 9i database on my Windows XP workstation and I have the production Oracle 9i on a unix server. I use Oracle Enterprise Manager (OEM) in my local database for creating my tables, sql plus etc. Now I was wondering if there is anyway to export and import my data...

For my Oracle SQL as a back end to my web applications I use Prepared Statements alot in my Java Database Connectivy (JDBC) working with Oracle 9i. I also heard the term Stored Procedure. What is the difference between Stored Procedure and Prepared Statement?

Just a follow up to my question....it looks like I need to have an Oracle database installed for it to find anything. It now works.

I have a free version of MySQL 4.1 running on our web server. I use it as a database for my Cold Fusion web applications. Please advise what are the advantages if I get newer MySQL version (5.0 and above)?

Thanks

Thanks, where do I find Tools/Folder Options/View area?

Thanks, I did compress the files. I tried changing in the Properties as you suggested and the color still stays blue, even after a reboot. Please advise.

On my Windows XP workstation the font color that list files in my C:\ folder and subfolders is now showing up in blue. Before it used to show up in black. Please advise how I change the font color back to black and why did the color change without me doing anything?

In Cold Fusion MX 7 admin page on my local web development server I can create a datasource with an Access database but when I try and create one with Oracle I get a message that says page not found. Do I need to load some sort of Oracle driver to get this work?

I build web applications and use different databases. Today our web server complained about Oracle having a Network error on all our web applications using Oracle from our Windows web server to our Oracle database on a Unix server. All other databases (SQL Server, Access and MySQL) I connect...