I have a table on my Oracle 10g database and one of the coulumn type of the table is LONG datatype. Although I can easily bind this field to Richtextbox and update it, I could not show this field on datagridview. I tried something on VS and PL/SQL procedures, but I have not managed to do. Could you inform me how to convert LONG to CHAR by PL/SQL or how to show LONG field on a datagridview please? Thanks in advance...
Check out below code that is used to select the LONG value in to VARCHAR2 variable:
EXECUTE IMMEDIATE 'SELECT b FROM tt2' INTO a;
PL/SQL procedure successfully completed.